Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 44443 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 compiled query?
How do sql triggers work?
Does varchar need length?
Does pl sql work in mysql?
how to fetch common records from two tables? : Sql dba
What does a pl/sql package consist of?
how to use in conditions? : Sql dba
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is a design view?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
Explain alias in sql?
How do I run sql profiler?
What does select count (*) mean in sql?
What are the operators used in select statements?
