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 is primary key, unique key, and foreign key?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What are number line correlation administrators will use while working with a subquery?
which table keeps the locking information? : Sql server administration
Do you know query execution plan?
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 is the contrast between sql and pl/sql?
What are the two authentication modes in sql server?
How to get a list of all tables with "sys.tables" view in ms sql server?
Where can you add custom error messages to sql server?
What are system databases in ms sql server?
What is the use of tempdb? What values does it hold?
Explain a join?
What is transact-sql ddl trigger?
Why would you use sql agent?