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

what are all the different normalizations? : Sql dba

1049

Is like operator in sql case sensitive?

1031

Is sqlite good enough for production?

998

Explain the structure of pl/sql in brief.

1096

What is pl/sql table? Why it is used?

1041

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

975

how can we destroy the session, how can we unset the variable of a session? : Sql dba

1005

Why do we use subquery?

1017

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2497

What is natural join in sql?

997

How do I view stored procedures?

980

What are aggregate and scalar functions?

1028

How does postgresql compare to oracle/db2/ms sql server/informix?

1039

how to do backup entire database? : Transact sql

1148

What are different categories of sql commands?

1135