Interested to Buy Any Domain ? << Click Here >> for more details...
write a query for the fifth highest salary?
- 17 Answers
- 24453 Views
- IBM, Matlabs, Ramco, I also Faced
- E-Mail Answers
Answer Posted / piyush gupta
select distinct(a.sal) from emp a where 5=(select
count(distinct(b.sal)) from emp b where a.sal<=b.sal)
you can this query for nth highest salary
replace 5 with any number
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Give the syntax of exception handling used in DBMS?
5. Explain about relational algebra.
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
issues involved in modeling and building data werahouses
What is the DIF format and when we will use in teradata
WHAT IS CARDINALITIES OF JOIN?
how can you perform lookup range in lookup stage expalin in detail?
What does currency type mean in database?
How many indexes can be created on a table?
What are the disadvantages of views in a database?
What is dialect in database?
Does facebook use graph database?
What is odm database?
What is the best database software for small businesses?
how can we view column head in first page but not in remaining pages?
