This challenge is to find the date based on year, month, day of the week and weekday number. Say for example, if the question is to find the date of 2nd Sunday of January 2010, the answer should be '2010-01-10'....

This challenge though does not have any resemblance with the real time problem directly, but it measures about logical thinking. The problem is all about finding the factorial of numbers...

<p>This challenge has been seen in one of the SQL Server forums. The challenge is all about merging the data based on certain conditions. </p>...

This problem is all about identifying all the employees directly or indirectly to whom the given Employee reports to. The challenge is to write a query that can take a Employee Id as a parameter and list all the employees to whom the Employee is reporti...

<p>The challenge is to find the employees with the second highest salary in each department. However, it is a little more complicated because if two employees have the same salary, you need to list both of them.</p>...

This challenge involves assigning food packets to birds from two different baskets. Your job is to read the input table and produce the required result set using a single PLSQL query....

This challenge is about finding second highest salary for each department...

This challenge invites you to play with date calculations. A lot of people are scared of date calculations and this challenge aims to help them to fight their fear!...

Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....

...