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 / vinay singh
To find any number of Salary..
Select * From Table E1 Where
(n-1) = (Select Count(Distinct(E2.Sal)) From Table E2
Where E2.Sal> E1.Sal)
**Vinay Singh
Is This Answer Correct ? | 8 Yes | 12 No |
Post New Answer View All Answers
what is a schema in sql server 2005? : Sql server database administration
What is difference between delete & truncate commands?
what is blocking? : Sql server database administration
what is the sql equivaent of the dataset relation object ?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
How can you find out how many rows returned in a cursor?
What are sql server functions?
What are relationships and mention different types of relationships in the dbms
How can windows applications connect to sql servers via odbc?
What is the main difference between ‘between’ and ‘in’ condition operators?
What are alternate keys?
How to create a simple stored procedure in ms sql server?
What are the types of database schema? : sql server analysis services, ssas
What is dbcc updateusage?
Define tool Manage Statistics in SQL Server 2000 query ?