find out the third highest salary?
Answer Posted / saleem
select distinct(a.sal) from emp a where &3 = ( select count
(distinct(b.sal) from emp b where a.sal <= b.sal));
| Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
How to delete a column in an existing table in oracle?
How to upsert (update or insert into a table)?
Can we write insert statement in function in oracle?
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.
What is translate in oracle?
What are the extensions used by oracle reports?
How to use existing values in update statements using oracle?
How to use an explicit cursor without open statements?
How to turn on or off recycle bin for the session?
Explain integrity constraint?
What privilege is needed for a user to create views in oracle?
Is it possible to split the print reviewer into more than one region ?
How do I uninstall oracle 11g?
How to define a data source name (dsn) in odbc manager?
How do I learn what codesets are available in oracle?