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

What is error ora-12154: tns:could not resolve the connect identifier specified?

1013

What is sql profiling in oracle?

992

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

1068

What is difference between db2 and sql?

935

What packages are available to pl/sql developers?

991

How to select random rows from a table?

1011

What is spool?

989

how to include character strings in sql statements? : Sql dba

999

what is sql profiler? : Sql dba

994

what is a database lock ? : Sql dba

1091

What is write ahead logging in sql server?

987

What is fmtonly in sql?

1000

What is the use of prepared statement?

951

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1062

Which tcp/ip port does sql server run?

953