how to find the fifth highest salary?
- 8 Answers
- 10186 Views
- IBM, Infosys, I also Faced
- E-Mail Answers
Answer Posted / soumen saha
select max(sal) from table where level=5 connect by prior
sal>sal;
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Are the resulting relations of PRODUCT and JOIN operation the same?
What is a two tier wage system?
What is 5NF?
what is the difference between LENGTH AND SIZE?
Not only RDBMS takes care of locating data it also
What are page splits? : sql server architect
What is the difference between a user defined function and a stored procedure?
What are the unary operations in Relational Algebra?
What do you mean by Correlated subquery?
When is a functional dependency F said to be minimal?
What is Set-at-a-time or Set-oriented?
What are the the Advantages of DBMS?
What is an Entity set?
What are the primitive operations common to all record management systems?
What is Data Independence?
