select ename from emp where sal=(select max(sal) from emp); ENAME

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

Question Posted / madhav

16 Answers
24039 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What are the different types of database management systems?

950

What is a join?

1020

what is the difference difference between procedure and packages

10250

What is string join?

932

Where is pl sql used?

904

Where is sql database stored?

919

How can we find duplicate records in a table?

891

How does one use sql*loader to load images, sound clips and documents? : aql loader

1118

What is the difference between sql and t sql?

964

What is vector point function?

1002

What is the difference between delete and truncate commands?

976

What is sql lookup?

864

What is sql procedures and functions?

955

what is heap table? : Sql dba

1047

What are the features of pl sql?

1013