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’s the use of custom fields in report?

920

What purpose does the model database server?

1075

What is difference between aggregate and analytic function?

906

Please illustrate physical database architecture? : SQL Server Architecture

968

Explain the difference between primary keys and foreign keys?

1004

What is a transactions?

1027

How do you debug a procedure in sql server?

926

What is subquery explain with example?

1042

What is the difference between SQL notification and SQL invalidation?

1154

What is the difference in accessing db between sql server vs sql azure?

174

How to view existing indexes on an given table using sys.indexes?

1070

What is the use of partition by in sql server?

910

What is triggers and stored procedures?

927

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

982

What are the requirements for sql server 2016?

871