Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 47556 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
Answer Posted / kavitha nedigunta
select a.*
from(select empno,ename,sal
from emp
order by sal desc nulls last)a
where rownum <6
order by sal desc
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
What is mdf ldf and ndf?
What is difference between sql and oracle?
How do I truncate a sql log file?
What does a pl/sql package consist of?
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?
Write a unique difference between a function and a stored procedure.
What is full form of rtm?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
Why use truncate instead of delete?
Can a foreign key have a different name?
Can a trigger call a stored procedure?
What are the two types of cursors in pl sql?
What is crud sql?
Explain what is a field in a database and record in a database?
How to call shell script from pl sql procedure?
