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

how to shut down the server with 'mysqladmin'? : Sql dba

990

What is mutating error in pl sql?

1002

Explain the rollback statement?

987

Does google use sql?

939

What is information schema in sql?

1053

Does access use sql?

1018

what is primary key? : Sql dba

1009

What are the ddl commands?

990

How can use stored procedures in sql?

1116

Does pdo prevent sql injection?

919

how to rename an existing table in mysql? : Sql dba

1045

Is pl sql still used?

961

What is a unique constraint?

1060

What is meant by <> in sql?

940

What are the differences between implicit and explicit cursors?

1049