select sal as Max_sal, ename from emp where sal IN( select max(sal) from

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

Question Posted / ram

Answer Posted / ram

select sal as Max_sal, ename from emp where sal
IN( select max(sal) from emp);

sun_ramprasad@yahoo.com

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is dbo in sql?

1019

What is difference between hql and sql?

1166

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1126

How do sql triggers work?

1096

Is sql the best database?

1030

Does a primary key have to be a number?

1004

define data blocks ? : Sql dba

1048

What are sql functions? Describe the different types of sql functions?

1215

What is record data type?

981

List the ways to get the count of records in a table?

943

what is sql in mysql? : Sql dba

1238

Is not equal in sql?

1064

What is difference between sql and mysql?

1197

what is bdb (berkeleydb)? : Sql dba

1093

What is the trigger in sql?

1004