Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 47559 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
Answer Posted / manoranjan sethy
Method 01:
---------
Select Ename, MAX (Sal) From Emp
Group by ROWNUM, Ename
Having Rownum <=5;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how can we repair a mysql table? : Sql dba
what are rollup and cube in t-sql? : Transact sql
What is where clause in sql?
What is %type in pl sql?
What is the left table in sql?
How many row comparison operators are used while working with a subquery?
What is the difference between having and a where in sql?
What is difference between pls_integer and integer?
What is the size of partition table?
what does it mean to have quoted_identifier on? : Sql dba
How do I find sql profiler?
What are all ddl commands?
Explain the difference between sql and mysql.
What is trigger price?
How to create your own reports in sql developer?
