find out the second highest salary?
Answer Posted / mallikarjun
select max(sal) from emp
where sal < select max (sal)from emp
Mallikarjun
Is This Answer Correct ? | 216 Yes | 86 No |
Post New Answer View All Answers
How to pass a cursor variable to a procedure?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What is java oracle used for?
How can Oracle users be audited?
IS it possible to built the oracle database without setting the kernal parameters?
How to bring a tablespace offline?
How to use fetch statement in a loop?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is the usage of merge statement?
What privilege is needed for a user to query tables in another schema?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
How to invoke the data pump import utility?
How to connect to oracle using service name instead of sid?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?