Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
Answer Posted / mk
SELECT ENAME,SALARY FROM (SELECT ENAME,SAL FROM EMP ORDER
BY SALARY DESC ) WHERE ROWNUM<6;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to get help information from the server? : Sql dba
What is a table in a database?
Who is the owner of mysql database?
What is normalization in a database?
What are different sql data types?
What is difference between hql and sql?
How do I use google cloud in sql?
What is trigger in sql?
What is the use of prepared statement?
What is coalesce in sql?
how to dump a table to a file with 'mysqldump'? : Sql dba
How do I make sql search faster?
How many sql are there?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is sql table?