Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 52259 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 exit statement?
What is clustered and nonclustered index in sql?
What is sqlca in db2?
what is union? : Sql dba
What is the syntax and use of the coalesce function?
What is a database? Explain
What is a unique key?
Why is pl sql needed?
What is triggering circuit?
What is embedded sql what are its advantages?
What is sql integrity?
How to use boolean type in select statement?
Why does sql need a server?
What is rtm in testing?
Enlist some predefined exceptions?
