find out the second highest salary?
Answer Posted / karthikeyan
select max(sal) from emp
where sal <(select max (sal)from emp);
Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What are the different types of synonyms?
How translate command is different from replace?
What is Segment Advisor in Oracle?
What is the usage of save points in oracle database?
What is not equal to in oracle?
What are the attributes of cursor?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How to use an explicit cursor without open statements?
How can we force the database to use the user specified rollback segment?
Explain the use of show option in imp command.
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.
Whats the benefit of dbms_stats over analyze?
What is a lookup table in oracle?
How do I know if oracle client is installed on windows?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?