Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / madhav
select ename from emp where sal=(select max(sal) from emp);
ENAME
---------
KING
--first execute the inner query like
select max(sal) from emp;
MAX(SAL)
---------
5000
--- after that salary value pass the outer query like
this
select ename from emp where sal=5000
ENAME
---------
KING
Email:thota.madhav@gmail.com
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
Should I use mbr or gpt?
Why is pl sql used?
Why primary key is required?
How do I view tables in sql developer?
Which join is like an inner join?
Why do we need cursors in pl sql?
What is the unique index?
Differentiate between pl/sql and sql?
Is it possible to create startup or shutdown trigger for on-schema?
What is sql deadlock?
what is a field in a database ? : Sql dba
Why function is used in sql?
Write the command to remove all players named sachin from the players table.
What is PL/SQL Records?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
