for example if we take emp table, the query like this... select a.sal fro

write a query to find 4th max salary

Question Posted / raj

Answer Posted / raj

for example if we take emp table, the query like this...
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 ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the purpose of %type and %rowtype data types with the example?

1043

What is schema in sql?

997

What is dbo in sql?

1015

What is scope of pl sql developer in future?

1065

How are functions and procedures called in PL/SQL?

1302

How do you update a table in sql?

1035

Does varchar need length?

1046

What are the advantages of sql? Explain

1148

Why is pl sql needed?

1000

Explain what is an index?

1102

what are aggregate and scalar functions? : Sql dba

1104

What is fmtonly in sql?

1155

How can you create an empty table from an existing table?

1123

Explain what is sql?

1174

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1220