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

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

Question Posted / suresh naik

Answer Posted / suresh naik

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

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1041

What problem one might face while writing log information to a data-base table in pl/sql?

1066

what is bcp? When does it used? : Sql dba

933

What is sqlite format?

1108

When should I use nosql database?

944

What is sql*plus?

1017

What is raid? How does it help storage of databases?

1033

What is rownum and rowid?

983

What are the possible values for the boolean data field?

900

What is sql catalog?

962

How does postgresql compare to mysql?

987

How can we debug in PL/SQL?

1090

How do you modify a column in sql?

938

How can you know that statistics should be updated?

1025

Do stored procedures prevent sql injection?

919