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 data locks are respected in oracle?
What is transaction control statement and how many types of transaction control statement in Oracle?
What happens to the current transaction if the session is killed?
How to pass parameters to procedures?
How to run the anonymous block again?
What is dynamic proxy?
How to view existing locks on the database?
How to loop through data rows in the implicit cursor?
How to sort the query output in oracle?
How to start an oracle instance?
What is the difference between postgresql and oracle?
How are extents allocated to a segment?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Explain coalesce function?