how to retrieve the top 3 salaries of the table using rownum
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 |
Post New Answer View All Answers
what is rdbms? : Sql dba
How many triggers can be applied on a table?
What do you mean by field in sql?
How do you add a column to a table?
What is a recursive stored procedure?
What are inbuilt functions in sql?
How will you distinguish a global variable with a local variable in pl/sql?
How do I view tables in sql developer?
Why is the cursor important?
What is secondary key?
State some properties of relational databases?
Which data type is a composite type?
What is union and union all keyword in sql?
How many subqueries can be nested in a statement?
How do I order columns in sql?