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

Is there any restriction on the use of union in embedded sql?

1162

Is sql microsoft?

1061

What is triggering circuit?

1073

how to rename an existing table in mysql? : Sql dba

1065

How many triggers can be applied to a table?

1069

What is bind variable in pl sql?

1059

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1043

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1134

what is the functionality of the function htmlentities? : Sql dba

971

Why use triggers in sql?

962

What is the difference between a subquery and a join?

1115

What is the maximum rows in csv?

931

what is the use of friend function? : Sql dba

1025

What is a sql trace file?

1035

Which is better stored procedure or query?

960