SQL Trick And Tips, Interview questions,Queries, examples to make developer's life easier than ever before..
My aim to create this blog is to write all such tricks and tips in SQL queries which will be helpful to my friends all over the world.
I want to share my experience about the SQL and hence i am too excited to start with....
Hope you all take me further over the web with my genuine intention to help you out with enjoyment of the technology......
Friday 19 March 2010
nth Highest Salary
--nth Highest Salary select min(Emp_Sal) from Employee_Test where Emp_Sal in(select distinct top n Emp_Sal from Employee_Test order by Emp_Sal desc)
