find out first highest salary?
Answer Posted / surya
select * from emp where &n-1=(select count(distinct sal)
from emp e where emp.sal<e.sal);
For example:-
If you enter n=1,it will display first highest salary
if you enter n=2,it will display second highest salary
......
if you enter n=nth,it will display nth salary
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Can we save images in a database and if yes, how?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to convert characters to times in oracle?
Why do we use bulk collect in oracle?
Why is oracle so popular?
Explain the use of parfile option in exp command.
What types of joins are used in writing subqueries?
What is meant by raw datatype?
How to create an oracle database?
Explain view?
How to rename an index?
defination of bitmap index
WHAT IS ecc 6.0
What is oracle rowcount?
Explain overloading. Can functions be overloaded?