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 / 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 parameterized reports?
Can two tables share a primary key?
What are the key configuration files for sql server reporting services ?
How many categories of functions based their return modes?
What do you mean by cardinality?
What information is maintained within the msdb database?
What is primary key, unique key, and foreign key?
Do I need a report server to run reports in my application?
Define cursor locking
What is RMS migrations?
How are the unique and primary key constraints different?
What are the types of lock supported by ?
What are the advantages of user defined function?
What are the new scripting capabilities of ssms? : sql server management studio
What are truncate options available in sql server? : sql server database administration