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

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

Question Posted / chandu

16 Answers
25023 Views
I also Faced
E-Mail Answers

Answer Posted / chandu

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

Is This Answer Correct ?

12 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how would you enter characters as hex numbers? : Sql dba

1038

What is difference between my sql and sql?

1140

What is nosql vs sql?

1227

How do sql triggers work?

1096

What is dml with example?

1156

What is index example?

1048

How many types of tables are there?

997

How do I find duplicates in the same column?

1172

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

4095

What is normalization in a database?

1198

how to drop an existing view in mysql? : Sql dba

1107

How does sql developer connect to oracle database?

1051

Is id a reserved word in sql?

1189

Is pl sql different from sql?

1045

How do you know if a relationship is 2nf?

995