how to get the second max val for every group in a table
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
When do you get a .pll extension in oracle?
Explain drop constraint oracle?
What is a subquery?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What is the relation of a user account and a schema?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is a directory object?
What is a trigger and what are its types?
Respected sir, Please send me technical questions related to oracle apps..
How to list all tables in your schema?
What do you mean by redo log file mirroring?
Explain oracle 12c new features for developers?
Explain about functional dependency and its relation with table design?
What types of joins are used in writing subqueries?
What is primefaces used for?