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
- 60279 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 options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What purpose does the model database server?
What is the syntax to execute the sys.dm_db_missing_index_details?
When would you use a before or after trigger?
How to optimize stored procedure optimization?
What is self contained scalar sub query?
What are the operating modes in which database mirroring runs?
How to create an index on a view?
What is built-in/administrator?
What is auditing in sql server?
What is GUID in sql server?
What are the steps you will take to improve the performance of a poor performing query?
What is user-defined scalar function?
What do we have to check in database testing?
What is sql injection and why is it a problem? : sql server security
