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
- 51381 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
What stored procedure can you use to display the current processes?
How can I add Reporting Services reports to my application?
What is normalization of database?
How to use clusters?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is the purpose of data source?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
what exactly sql injuction.how to overcome.....
How to handle error or exception in sql?
How to use subqueries in the from clause in ms sql server?
How extra digits are handled with numeric data type literals?
How to define the name and server for a new dsn?
What are window functions in sql server?
How to enter binary string literals in ms sql server?
