Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 47511 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
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 delete a row in sql?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
Why do we use partitions in sql?
When is the update_statistics command used?
What has stored procedures in sql?
Can we delete column in sql?
What is trigger and how to use it in sql?
how to do backup entire database? : Transact sql
how can we know the count/number of elements of an array? : Sql dba
Is there any restriction on the use of union in embedded sql?
What does the file extension accdb stand for?
Does pl sql work in mysql?
How many triggers can be applied on a table?
What is the use of count (*) in sql?
what is a primary key? : Sql dba
