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

What is orm in sql?

1052

How do you rename a table in sql?

1118

Why do we use sql constraints?

1175

What will you get by the cursor attribute sql%rowcount?

1042

how to extract a unit value from a date and time? : Sql dba

994

How do I view a sql trace file?

1035

Is a secondary key the same as a foreign key?

1038

How do I pipe the output of one isql to another?

1007

what is sub-query? : Transact sql

1108

What is pl sql in dbms?

954

What do you mean by stored procedures? How do we use it?

996

What is the difference between local and global temporary table?

1048

how can we know the count/number of elements of an array? : Sql dba

1063

How do I know if I have sql express or standard?

1035

What is trigger and stored procedure in sql?

1042