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
Can you roll back the ddl statement in a trigger?
what is database replication? : Sql server database administration
What is the contrast amongst drop and truncate?
Define synonym?
What are the requirements to use odbc connections in php scripts?
What is the difference between stored procedure and user defined functions?
How ssrs maintain security?
what is the difference between a primary key and a unique key? : Sql server database administration
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What is etl - extraction, transformation, and loading?
What extended events?
Do you know the policy based administration feature of sql server 2008?
what is the sql equivaent of the dataset relation object ?
What is a sql join?
Explain transaction isolation levels in sql server?