Answer Posted / sasi
select * from
(select sal,rank() over (order by sal desc) emprank from emp)
where emprank<=3
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what is 'mysqldump'? : Sql dba
What are stored procedures in mysql?
What is normalization in sql?
What are the operators used in select statements?
What is a primary key sql?
How do you select unique values in sql?
What packages are available to pl/sql developers?
What are the types of sql commands?
Can you join views in sql?
Define the select into statement.
What is left join in sql?
How to use transactions efficiently : transact sql
What is a crud api?
What is a record in pl/sql?
Is it possible for a table to have more than one foreign key?