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
24672 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

How to select 10 records from a table?

1159

What is normalisation in sql?

1065

What is a loop in sql?

989

What is sql in java?

1091

what are date and time intervals? : Sql dba

1060

What is error ora-01000: maximum open cursors exceeded

1147

Explain the insert into statements in sql?

1010

What is the difference between left join and right join?

948

what is the difference between char_length and length? : Sql dba

1049

What is the difference between row level and statement level trigger?

1025

What are the string functions in sql?

980

How sql query is executed?

1136

What is the clause we need to add in function body to return variable?

1013

What are the 3 modes of parameter?

1156

what is data integrity? : Sql dba

1040