select e.ename,e.sal from emp e where 3>(select count (distinct(b.sal))

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

Question Posted / kalyan kumar

Answer Posted / kalyan kumar

select e.ename,e.sal from emp e where 3>(select count
(distinct(b.sal)) from emp b where b.sal>e.sal)

Is This Answer Correct ?

19 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What is the difference between local and global temporary table?

1046

What is trigger and stored procedure in sql?

1034

What are different categories of sql commands?

1133

What is the use of index in hive?

1007

How insert into statements in sql?

1072

How does postgresql compare to mysql?

1034

What is left join in sql?

1049

Explain mutating table error.

1204

What is record data type?

916

What are pl sql procedures?

1024

Will truncate release space?

950

What does select * from mean in sql?

3238

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1158

What normalization means?

978

What is the difference between joins?

1039