Select Top 1 (Salary) from emp where salary not in (select Top 3 (Salary)

write query for fourth maximum salary from employee table

Question Posted / pramod

Answer Posted / pramod

Select Top 1 (Salary) from emp where salary not in
(select Top 3 (Salary) from emp order by salary desc)
order by salary desc

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

how would you improve etl (extract, transform, load) throughput?

1075

Which database stores information about replication?

1127

What are subquery and its properties?

1102

How to get a list of columns using the "sys.columns" view in ms sql server?

1008

What is sql server locking?

1036

How to convert character strings into numeric values?

1150

Is sql server 2016 free?

981

What are the kinds of subquery?

1072

You want to implement the one-to-one relationship while designing tables. How would you do it?

1014

Can group by and orderby be used together?

1069

How to get the definition of a stored procedure back?

1020

What do you mean by an execution plan? How would you view it?

963

Tell me what are the essential components of sql server service broker?

987

Can we insert data into a view?

1194

What are click through reports?

149