Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 58931 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 is an index? : Sql server database administration
What are the advantages of stored procedure in sql server?
How can you set the threshold at which sql server will generate keysets asynchronously?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
How to write an inner join with the where clause in ms sql server?
Define self join?
What happens when converting big values to numeric data types?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
How to recompile stored procedure at run time?
What is mean by dml?
What is row_number () and partition by in sql server?
Explain what role entity and relationship play in an ER diagram.
How we can refresh the view?
What is it unwise to create wide clustered index keys?
Comment,Datatypes are unlimited
