how to find nth highest salary
- 103 Answers
- 163920 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
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 three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
How to update multiple rows with one update statement in ms sql server?
What is the syntax for encrypting a column in SQL Server?
How to use copy and concatenate commands in SQL?
How do I create a stored procedure in sql server?
What is the difference between locking and multi-versioning?
What are the differences between decimal and float in ms sql server?
what is denormalization? : Sql server database administration
Does table partitioning improve performance?
Difference between uniqe index and uniqe constraint?
What are the types of subscriptions in SQL Server replication?
According to you what goes into making the best database administrator? : sql server database administration
What is database white box testing?
What is built-in function?
What is scalar user-defined function?
