Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 44659 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
Answer Posted / priya
SELECT Rownum,emp-name,salary
FROM(SELECT emp_name,salary
FROM employees
ORDER BY salary Desc)
WHERE Rownum<=5;
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
What is dynamic query?
What is sql and its types?
Is sql a backend?
what are the advantages a stored procedure? : Sql dba
How to write a query to show the details of a student from students table whose
Can we call dml statement in function?
what are date and time data types in mysql? : Sql dba
Can we use threading in pl/sql?
what is rollback? : Sql dba
What is minus?
What is the difference between row level and statement level trigger?
Which is faster view or stored procedure?
What is pl sql block structure?
Explain the advantages and disadvantages of stored procedure?
What is a primary key sql?
