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
- 58930 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / yogesh
A little correction:
sol2> select salary from emp order by salary desc limit 1,1;
select salary from emp order by salary desc limit n-1,1;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Can a trigger be created on a view?
What is the contrast between sql and pl/sql?
What are the types of sql server?
How to create a scrollable cursor with the scroll option?
What is a constant or literal in ms sql server?
What is database isolation in sql server? : sql server database administration
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What are the different ways you can create databases in sql server?
What do you understand by the analysis services in sql server?
what is an index? : Sql server database administration
How to get a list of columns using the "sys.columns" view in ms sql server?
what is difference between view and Dip.
Why use view instead of a table?
Explain for xml explicit mode?
Explain what are the different index configurations a table can have?
