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
Do you know what is similarity and difference between truncate and delete in sql?
What are the advantages dts has over bcp?
What are the tool windows in sql server management studio? : sql server management studio
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
Explain about sql server login?
What are different types of statement?
What is a covered index?
How to create function without parameter in sql server?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
System variable and temporary variables
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What you can do to delete a table without the delete trigger firing?
Differentiate between a having clause and a where clause.
How to return the date part only from a sql server datetime datatype?
What is the difference between the 2 operating modes of database mirroring?