select top 1 salary from (select distinct top 4 Salary from tablename

write query for fourth maximum salary from employee table

Question Posted / icedrop

Answer Posted / icedrop

select top 1 salary from (select distinct top 4 Salary from tablename order by salary desc ) result order by salary

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are statistics?

1051

What are the different types of collation sensitivity in sql server?

1168

What is a Join and explain its types?

1152

Mention the different types of triggers?

1203

How do I start and stop sql server?

1063

What is the use of sql profiler in sql server 2012?

943

What are alternate keys?

1031

What is the distinction amongst delete and truncate?

1111

What does it mean if @@cursor_row returns a negative number?

1038

What is Dependency Injection and provide example?

1179

What are wait types?

1200

What are sub reports and how to create them?

144

what is database replicaion? : Sql server database administration

1271

How will you know when statistics on a table are obsolete?

1129

How to create a user name in a database?

1103