how to find nth highest salary
Answer Posted / ravindra babu
select sal from (select sal from(Select distinct sal from
EMP order by sal desc)Where rownum <=2 order by sal asc)
Where rownum=1;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are recommended options to be used while using db mirroring? : sql server database administration
What are the dis_advantages of stored procedures, triggers, indexes?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
How to throw custom exception in Stored Procedure?
what are constraints? : Sql server database administration
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
What is service broker?
Is it possible to replicate data from sql server to oracle? : sql server replication
How do you delete duplicate rows in sql server?
What is meant by indexing?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is difference between delete & truncate commands?
What is the difference between createstatement and preparedstatement?
What is sql sandbox in sql server?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture