how to retrieve the top 3 salaries of the table using rownum
Answer Posted / vik
select empno, ename, sal from (select * from emp order by
sal desc) where rownum < 4
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are sql ddl commands?
What are different types of statements supported by sql?
what are date and time data types in mysql? : Sql dba
What is sql*loader and what is it used for? : aql loader
What is sqlite used for?
What is full join in sql?
what is a composite primary key ? : Sql dba
what are integrity rules?
What is vector point function?
What is raw datatype in sql?
what is the difference between a local and a global temporary table? : Sql dba
What are the types of queries in sql?
how to include character strings in sql statements? : Sql dba
what is sql? : Sql dba
what is text? : Sql dba