select ename, salary from emp where salary=(select max (salary) from emp)

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

Question Posted / selvaraj v , anna university c

select ename, salary from emp where salary=(select max
(salary) from emp) order by emp_no;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a sql select statement?

1041

Does a user_objects view have an entry for a trigger?

1012

Is natural join same as inner join?

943

What is hibernate and its relation to sql?

1124

What does count (*) mean?

933

Explain the uses of control file.

1050

Does sql full backup truncate logs?

1017

what is csv? : Sql dba

999

what are date and time data types? : Sql dba

984

What does pl sql stand for?

1117

What is a rank in sql?

963

Can we call stored procedure in function?

959

How do I trace sql profiler?

985

What is indexes?

1058

What is sap sql?

983