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 happens if null values are involved in expressions? : Sql dba

999

Can we use pl sql in sql server?

1010

how many ways we can we find the current date using mysql? : Sql dba

1034

What are hotfixes and patches?

883

Are left and right joins the same?

997

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

992

Can we commit in trigger?

920

How many sql statements are used?

956

How to process query result in pl/sql?

1058

What is sql character function?

993

How many joins can you have in sql?

880

How do you optimize a stored procedure query?

936

What is the trigger in sql?

899

what is try_catch block in procedure

1653

How do I create a sql database?

947