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
- 35 Answers
- 51656 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / gunjan sapra
select top 10 from tbl_name order by salary desc
| Is This Answer Correct ? | 4 Yes | 39 No |
Post New Answer View All Answers
What are the benefits of filtered indexes?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What is a fill factor?
How do you debug a procedure in sql server?
Define left outer join?
What are clustered and non-clustered index?
What is forward - only cursors / read only cursor?
What is reportserver and reportservertempdb ?
What do you understand by physical_only option in dbcc checkdb?
What happens if you insert a duplicate key for the primary key column in ms sql server?
Where are sql server usernames and passwords stored in the sql server?
How do I start sql server?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
how many type of indexing in database?
What are the differences between substr and charindex in sql server.
