Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
- 8 Answers
- 11496 Views
- I also Faced
- E-Mail Answers
Answer Posted / shashank tayal
select salary from table_name order by desc limit 3,1;
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to find the second highest salary of an employee?
What are the differences between web role and worker role?
What is RAID? What are the different types of RAID configurations?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What is a derived table?
How to replace the Query Result 'Null Value' with a text ?
What is a transactions?
Explain can you implement data mining in ssrs?
Differentiate between a local and a global temporary table?
how would you troubleshoot blocking? : Sql server database administration
What are the five major components of a dbms?
List out some of the requirements to set up a sql server failover cluster?
Do you know what is normalization of database? What are its benefits?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
Do you know the capabilities of cursors?
