Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 64121 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / raghav
SELECT MAX(SAL)
FROM EMPLOY
WHERE SAL < ( SELECT MAX(SAL) FROM EMPLOY )
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
Why do we need oracle client?
How to export data with a field delimiter?
What is the data type of dual table?
How to execute the package in oracle?
Why does for update in oracle 8 cause an ora-01002 error?
Is there an oracle sql query that aggregates multiple rows into one row?
What is the purpose of save points in oracle database?
does the query needs a hint to access a materialized view?
Query to retrieve record for a many to many relationship ?
How do I limit the number of rows returned by an oracle query after ordering?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
what is the difference between restoring and recovering?
How to put more than 1000 values into an oracle in clause?
How to write an inner join with the where clause in oracle?
How many types of table in Oracle?
