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 is normalization of database? What are its benefits?

963

Where views are stored in sql server?

926

How to execute multiple stored procedures at one time in sql server?

945

between cast and convert which function would you prefer and why?

917

Find columns used in stored procedure?

938

How to insert multiple rows with one insert statement in ms sql server?

1057

How to set the current database in ms sql server?

1012

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1625

What are the commands used in DCL?

969

How to find the service pack installed? : sql server database administration

975

What is the maximum row of a size?

957

How do you size a resultset?

878

What is use of @@ spid in sql server?

1149

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1019

What is scheduled job and how to create it?

925