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

how many values can the set function of mysql take? : Sql dba

1039

What is an inconsistent dependency?

1087

What is dbo in sql?

1019

how do you know if your mysql server is alive? : Sql dba

1130

What is the difference between partition and index?

1061

what is the difference between primary key and unique key? : Sql dba

1086

How many sql commands are there?

1159

What is a unique key and primary key and foreign key?

1022

what are date and time data types? : Sql dba

1028

What is java sql package?

1145

How do I save a sql query?

1067

What is server name sql?

1207

How do I run sql profiler?

1118

What is sql architecture?

1102

What does closing a cursor do?

1375