Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 44498 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
What are the rules to be applied to nulls whilst doing comparisons?
What company owns postgresql?
How sql query is executed?
Why trigger is used in sql?
How do I find duplicates in the same column?
How to fix oracle error ora-00942: table or view does not exist
What are the topics in pl sql?
how to use myisamchk to check or repair myisam tables? : Sql dba
What is self-join and what is the requirement of self-join?
What is break?
What is the use of partition by in sql?
What is pl sql in dbms?
Why coalesce is used in sql?
how to enter characters as hex numbers? : Sql dba
Explain ttitle and btitle.
