Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mk
select *from emp where sal=(select distinct(max(sal)) from
emp where sal <select max(sal) from emp )
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to define a specific record type?
How is it different from a normal table?
How will you write a query to get a 5th rank student from a table student_report?
What is user managed backup in Oracle?
What types of joins are used in writing subqueries?
How do I spool to a csv formatted file using sqlplus?
What do you mean by group by clause?
How to run queries on external tables?
How would you begin to troubleshoot an ORA-3113 error?
Differentiate between pre-select and pre-query?
How to insert a new row into a table in oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
Explain the types of exception?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to convert characters to numbers in oracle?
