select empnumber from emp where rownmum < 4 and salary in (select sa

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

Question Posted / ashwinee

Answer Posted / ashwinee

select empnumber
from emp
where rownmum < 4 and salary in (select salary
from emp
order by salary desc)

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is on delete set null?

1037

What are the different types of functions in sql?

995

What is bulk compiling in pl/sql.?

1060

What is vector point function?

1001

What are the steps for performance tuning.

1267

What is sequence in sql?

937

what is an index? : Sql dba

929

What is procedure and function in sql?

927

What are some predefined exceptions in pl/sql?

1063

write an sql query to find names of employee start with 'a'? : Sql dba

964

What is procedure explain with example?

893

What is coalesce in sql?

970

What is difference between procedure and trigger?

914

what is a unique key ? : Sql dba

1025

What is the difference between count 1 and count (*) in a sql query?

907