Interested to Buy Any Domain ? << Click Here >> for more details...
how to select second mauximum value in a given table under salary column
- 6 Answers
- 9400 Views
- Sapient, I also Faced
- E-Mail Answers
Answer Posted / jai
SELECT MAX(SALARY) FROM EMPLOYEE
WHERE SALARY NOT IN(SELECT MAX(SALARY) FROM EMPLOYEE)
| Is This Answer Correct ? | 27 Yes | 2 No |
Post New Answer View All Answers
What are advantages of dateset in datastage?
Why does oracle 9i treat an empty string as null?
What is the maximum number of triggers that can be applied to a single table?
What is a sub query and what are the different types of subqueries?
What is the difference between a user and a schema in oracle?
What is max rowid in oracle?
How to best split csv strings in oracle 9i?
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 I spool in oracle?
How to define an oracle cursor variable?
How to define a data field as not null?
How to use "in" parameter properly?
How to pass parameters to procedures?
How to call a stored function in oracle?
How to delete an existing row from a table in oracle?
