how to find nth highest salary
Answer Posted / mohd javed
BY Tested in Postgres SQL : javedcc@gmail.com
select * from tablename as aliasname where (nth)= (select
count(sal) from tablename where aliasname.sal<=sal)
| Is This Answer Correct ? | 8 Yes | 16 No |
Post New Answer View All Answers
What are the restrictions that views have to follow?
List the different index configurations possible for a table?
What are the five characteristics of good data?
how can you attach more than 20 ldf files in sql server
When I delete any data from a table, does the sql server reduce the size of that table?
List the ways in which dynamic sql can be executed?
What is factless fact table? : sql server analysis services, ssas
Explain magic tables in sql server?
How to delete a login name in ms sql server?
How to connect to SQL Azure Database by using sqlcmd?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What is the difference between NOROW and LOCKROW?
How to disable stored procedure sql server?
 Explain what is sql override for a source taLle in a mapping?
What stored by the model? : sql server database administration