Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
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
What happens if you add a new index to large table?
Describe the left outer join & right outer join. : sql server database administration
can you implement data mining in SSRS?
What kind of problems occurs if we do not implement proper locking strategy?
How to fine-tune reports?
How to use user defined functions in expressions?
Explain time data type in sal server 2008?
How to update muliple row in single query?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
How efficient you are in oracle and SQL server?
Give me a SQL Query to find out the second largest company?
How to enter unicode character string literals in ms sql server?
How to create a login account in ms sql server to access the database engine using "create login" statements?
Explain what is dbcc?
State a few properties of relational databases?