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

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

Question Posted / nagendra

16 Answers
24506 Views
I also Faced
E-Mail Answers

Answer Posted / nagendra

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you delete data from a table?

1010

Which join is default?

936

what are the differences between char and varchar? : Sql dba

1059

what is the difference between a having clause and a where clause? : Sql dba

1062

What is pl sql record in oracle?

1011

Explain what is a view?

1044

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1580

What are field types?

978

What are the qualities of 2nf?

1023

What are the indexing methods?

1029

What are the ways on commenting in a pl/sql code?

1115

What are pl/sql cursors?

1037

What is sql engine in oracle?

972

What are sql queries used for?

1008

What is meant by truncate in sql?

1046