find out the third highest salary?
Answer Posted / narendra
select max(company_id) from company where company_id <
(select max(company_id) from company where company_id <
(select max(company_id) from company))
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to count duplicated values in a column in oracle?
What is the usage of merge statement?
What is recovery manager(rman) backup in Oracle?
What is the difference between $oracle_base and $oracle_home?
How different is ms access and oracle?
Explain oracle’s system global area (sga).
Where do you use decode and case statements?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What are the advantages of oracle?
What is a procedure in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
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 a cursor in oracle?
Why do we need integrity constraints in a database?
What is oracle data type?