Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the second max val for every group in a table
- 6 Answers
- 9703 Views
- Verizon, I also Faced
- E-Mail Answers
Answer Posted / indu
select max(sal) from salary where sal NOT IN (select max(sal) from salary)
| Is This Answer Correct ? | 9 Yes | 13 No |
Post New Answer View All Answers
How to create a stored program unit?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How many types of cluster table in Oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What is difference between cartesian join and cross join?
What are the various constraints used in oracle?
How many file formats are supported to export data?
What is Trigger in Oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
Compare and contrast between sql and sql server and explain its various functions?
Explain the difference between replace() and translate() functions in oracle?
How to write numeric literals in oracle?
What is sharded cluster?
