select sal from emp a where 3>(select count(distinct(sal))from emp b wh

how to retrieve the top 3 salaries of the table using rownum

Question Posted / swapnareddy

Answer Posted / swapnareddy

select sal from emp a where 3>(select
count(distinct(sal))from emp b where a.sal<b.sal);

Is This Answer Correct ?

4 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Does sql backup shrink transaction log?

953

How to place comments in pl/sql?

1141

What are sql procedures?

1005

How to test for null values?

1023

What is compute?

1071

What does the hierarchical profiler does?

1047

Which is better cte or subquery?

1012

how to include character strings in sql statements? : Sql dba

1044

What is the difference between unique and primary key constraints?

1047

What is snowflake sql?

1049

Explain what is dbms?

1038

Can you sum a count in sql?

985

What is difference between sql and excel?

1067

How will you distinguish a global variable with a local variable in pl/sql?

1131

Why does sql need a server?

1019