How to create a dll in dotnet
To get something you never had, you have to do something you never did-Bimal Patel
Query to find the nth highest salary
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
This query will work in MSSQL.What about other databases.Always try to write ANSI select statements.
ReplyDeleteJust try this if you are not able let me know
I am always here to help you
You can always share your queries here
ReplyDelete