select employee_id,last_name,salary from employees where rownum <=3 o

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

Question Posted / kavitha

Answer Posted / kavitha

select employee_id,last_name,salary
from employees
where rownum <=3
order by salary desc

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is rdbms? : Sql dba

1066

How many triggers can be applied on a table?

988

What do you mean by field in sql?

1129

How do you add a column to a table?

1105

What is a recursive stored procedure?

1253

What are inbuilt functions in sql?

1109

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

1203

How do I view tables in sql developer?

1009

Why is the cursor important?

1081

What is secondary key?

989

State some properties of relational databases?

1115

Which data type is a composite type?

1037

What is union and union all keyword in sql?

1111

How many subqueries can be nested in a statement?

1042

How do I order columns in sql?

1073