how to retrieve the top 3 salaries of the table using rownum
Answer Posted / raghunanda
SELECT * FROM(SELECT * FROM EMP ORDER BY SAL DESC) WHERE ROWNUM<=3;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different sql languages?
Is ms sql traffic encrypted?
What do you think about pl/sql?
What is left join example?
What is the size of partition table?
How would you reference column values before and after you have inserted and deleted triggers?
What is coalesce sql?
How do I create a sql script?
Explain raise_application_error.
How do you copy a table in sql?
What is database sql?
what are different types of collation sensitivity? : Sql dba
Can a table contain multiple foreign key’s?
how to select unique records from a table? : Sql dba
Can a composite key be null?