How to Select second Maximum salary in a Table ?
Answer Posted / guest
select max(sal) from Table
where sal not in(select max(sal) from Table);
| Is This Answer Correct ? | 20 Yes | 3 No |
Post New Answer View All Answers
What is a user account in oracle?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What is oracle and what are its different editions?
What is a named program unit?
How to convert a date to char in oracle? Give one example.
How to write an inner join with the where clause in oracle?
Can you create a synonym without having a table?
Explain the dml?
Point out the difference between user tables and data dictionary?
what is dynamic SGA and static SGA
When do I need to use a semicolon vs a slash in oracle sql?
Is it possible to split the print reviewer into more than one region ?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is not equal to in oracle?
what is the dual table in oracle?