for example if we take emp table: select a.sal from emp a where 4=(selec

write a query to find 4th max salary

Question Posted / raj

Answer Posted / raj

for example if we take emp table:

select a.sal from emp a where 4=(select count(distinct(b.sal)) from emp b where a.sal<=b.sal);

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Why stored procedure is better than query?

884

Do we need commit after truncate?

1028

Why do we need sharding?

936

what is a database transaction? : Sql dba

1105

explain mysql aggregate functions. : Sql dba

939

How do you remove duplicate records from a table?

884

What is procedure explain with program?

949

What is posting?

990

how to convert character strings to numeric values? : Sql dba

1023

Write a unique difference between a function and a stored procedure.

924

How do you rename a table in sql?

1028

What are sql built in functions?

893

What is the use of non clustered index?

927

How do I write a sql query in pgadmin 4?

923

Are stored procedures faster than queries?

897