How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
Answer Posted / riyazkhan
select Sal from Employee where Sal != (select max(Sal) from Employee) Order By Sal desc
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the meaning of sql server?
How we create SQL Server 2005 Reporting Services ? Give me Sample
What are data resources?
How to link tables in sql server?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
How to insert data with null values?
What is a Join and explain its types?
What is the difference between clustered and non-clustered indexes in ms sql server?
What are the advantages of having an index on the sql server?
Do you know hot add cpu in sql server 2008?
How you can get a list of all the table constraints in a database?
Why do you need a sql server?
How to define and use table alias names in ms sql server?
what are user defined datatypes? : Sql server database administration
What are pages and extents? : SQL Server Architecture