This book is for All Database Developers and Developers Administrators. This book will flow in a “Question & Answer” mode from start to finish to help you grasp concepts faster and get to the point quickly. ...

Nice one. It's more simplest way. Thanks

@Durga: Please let me know if you have some better solution

<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>...

Solution to TSQL Beginners Challenge 1...