How to Select second Maximum salary in a Table ?
Answer Posted / ranjini
select max(salary) from employee not exists (select
max(salary)from employee)
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to connect to oracle using service name instead of sid?
How to insert a new row into a table in oracle?
Where do you use decode and case statements?
What is recovery manager(rman) backup in Oracle?
What is recycle bin in Oracle?
How do I manually uninstall oracle client?
Explain joins in oracle?
What is a named program unit?
What are the arithmetic operations?
Please explain joins in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
What is the scope of a local variable?
Which is faster join or subquery in oracle?
Please explain drop constraint oracle?
Give the various rollback segment states.