select salary from table_name order by desc limit 3,1;

Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)

Question Posted / shashank tayal

Answer Posted / shashank tayal

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

949

what type of index will get created after executing the above statement? : Sql server database administration

920

Will sql server 2005 allow you to reduce the size of a column?

917

How do I determine how many instances of sql server are installed on a computer?

958

What are page splits?

958

What is the difference between nvl and nvl2?

897

Difference between drill down and drill through report.

900

explain different types of cursors? : Sql server database administration

1024

What is a ddl statement?

853

How to check if stored procedure is running in sql server?

960

Can we write a distributed query and get some data which is located on other server and oracle database?

1176

Explain about builtinadministrator?

986

What are translations and its use? : sql server analysis services, ssas

993

What are the disadvantages of primary key and foreign key in SQL?

1048

What is the difference between drop table and truncate table?

873