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

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

Question Posted / pramod janjirala

Answer Posted / pramod janjirala

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

Is This Answer Correct ?

32 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Is it possible to link two groups inside a cross products after the cross products group has been created?

997

What are different types of sql commands?

1097

Mention what are the benefits of pl/sql packages?

1062

how to check server status with 'mysqladmin'? : Sql dba

1059

What is the difference between count 1 and count (*) in a sql query?

969

What is AUTH_ID and AUTH_USER in pl/sql ?

2171

How does rowid help in running a query faster?

1404

Can we alter stored procedure?

971

What is the basic form of sql query?

927

What are the two parts of design view?

1008

How delete all data from table in sql?

1005

How do we use distinct statement? What is its use?

1016

What is java sql driver?

1095

What is an ndf file?

977

what is 'trigger' in sql? : Sql dba

1071