Monthly Archive:: November 2013

29 Nov 2013

Finding the Nth highest value in a table

I recently was asked by a colleague about finding the Nth highest value in a table. For example if there is an employee table then finding the 10th highest salary or something similar. I thought about it
8 Nov 2013

Experience with MS SQL Server

After years of experience with SQL server, I have gathered some of the practices that are good for writing SQL queries, procedures and functions. Here is my work as presentation, enjoy!! Sql good practices from Deepak Mehtani