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

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

Question Posted / manoj k

Answer Posted / manoj k

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

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the size of partition table?

1088

What language is oracle sql developer?

1069

What is a delimiter in sas?

1124

What is nvarchar max in sql?

1072

Can we use commit inside a trigger?

1144

what are ddl statements in mysql? : Sql dba

1263

What are the two characteristics of a primary key?

1029

Is left join faster than join?

1096

Is trigger a stored procedure?

979

what does myisamchk do? : Sql dba

1079

What is the difference between sql and isql*plus?

1160

How do we accept inputs from user during runtime?

1116

What do you mean by stored procedures?

1067

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1243

What is sql integrity?

1239