find out the third highest salary?
Answer Posted / tejeswara rao potnuru
Find Out The Nth Highest Salary
SELECT MAX(SAL),LEVEL FROM EMP
WHERE LEVEL=&LEVELNO
CONNECT BY PRIOR SAL>SAL
GROUP BY LEVEL;
Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
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 do you store pictures in a database?
How to delete a column in an existing table in oracle?
How to use select statement to count the number of rows in oracle?
How to open a cursor variable?
What are temporal data types in oracle?
Can group functions be used in the order by clause in oracle?
What is the difference between sharding and partitioning?
What are the limitations of check constraint?
Explain the use of full option in exp command.
What is an index associated with a constraint?
Why do we need oracle client?
What is a cursor in oracle?
How can we create the complete backup of data in the oracle.
Explain the use of consistent option in exp command.