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
What are the different types of database management systems?
What is a join?
what is the difference difference between procedure and packages
What is string join?
Where is pl sql used?
Where is sql database stored?
How can we find duplicate records in a table?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is the difference between sql and t sql?
What is vector point function?
What is the difference between delete and truncate commands?
What is sql lookup?
What is sql procedures and functions?
what is heap table? : Sql dba
What are the features of pl sql?