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

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

Question Posted / nagendra

Answer Posted / nagendra

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can sql developer connect to db2?

1104

what is index? : Sql dba

1045

How do I partition a table in sql?

1209

How do you concatenate in sql?

1086

What is delimiter sql?

1060

What are the uses of merge?

1227

How do I add a primary key to a table?

1085

how can you see all indexes defined for a table? : Sql dba

1053

what are the different index configurations a table can have? : Sql dba

1043

Write a query to find the names of users that begin with "um" in sql?

1045

What are reports usually used for?

1085

Is record in pl sql?

1013

Why stored procedure is faster than query?

1158

Why use stored procedures?

1142

What is bulk collect in pl sql?

1158