|
|
-
<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 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...
|
|
|
-
Sheldon Submitted 1 Months ago through TSQL Beginners Challenges
Found this quite the challenge, as I've never handled this type of date manipulation. I returned null instead of invalid date as I don't like to save dates as characters....
|
-
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 includes couple of iterations....
|
|
|
|
|
-
The challenge is to implement similarly functionality in TSQL, that works similar to TRANSLATE function of ORACLE. ...
|
-
Hi,
Solution should include grouping of data based on Department and Ordered on Salary....
|
-
<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>...
|
-
Bhakti Submitted 2 Months ago through TSQL Beginners Challenges
Hi,
Solution should include grouping of data based on Department and then Order according to Salary...
|
|
|
-
This is giving expected result. Please check again....
|
|
|
-
This challenge aims to test your string parsing and summarizing skills using TSQL. The challenge is to count the number of mobile phones each person has and generate a summary row....
|
|
|
-
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...
|