write a query for the fifth highest salary?
Answer Posted / aravind
select * from (select sal from emp order by desc) emp where
rownum = 5
| Is This Answer Correct ? | 6 Yes | 14 No |
Post New Answer View All Answers
What is the best database software for small businesses?
Explain data independence & its types.
issues involved in modeling and building data werahouses
if i want to display the name of students such that to which city they belong must have count greaer than two
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
What are indexes in oracle?
Is it good to store images in database?
What is ole db used for?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
What is the best database?
What are different types of clusters present?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
What is the difference between primary and candidate key?
Why merge statement is used inside the database?
Explain alternate key?