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
25015 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 tsql statements can be written and submitted to the database engine? : Transact sql

1037

Is left join faster than inner join?

1170

What is %s in sql?

1080

How do you determine the current isolation level? : Transact sql

1206

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1136

What is linq to sql?

1180

What is db journal file?

1157

What is left inner join in sql?

1097

What is relationship? How many types of relationship are there?

1264

What do we need to check in database testing?

1066

State some properties of relational databases?

1115

What are the most important characteristics of pl/sql?

1228

How many commands are in sql?

1121

What is replication id?

989

What is dense_rank in sql?

1045