a query to select maxmun 3 salaries of employee table
Answers were Sorted based on User's Feedback
Answer / neo devan
select max(sal) from emp having max(sal)!=(select max(sal)
from emp where max(sal)!=(select max(sal) from emp));
| Is This Answer Correct ? | 0 Yes | 4 No |
what is the use of ondelete cascade?
what is the uses of cusor
What is oracle rownum?
How do we switch from init.ora file to asp file?
How are Indexes Update ?
Query to retrieve record for a many to many relationship ?
What is rowid and rownum in oracle?
what are different types of locks?
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
What are the built-in functions used for sending Parameters to forms ?
how may join possible between (requisition with purchase order)
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?