SELECT ENAME FROM TABLE NAME WHERE SAL>(SELECT MAX(SAL) FROM TABLE NAM

consider a table which contain 4 columns,ename,eno,sal and
deptno, from this table i want to know ename who having
maximum salary in deptno 10 and 20.

Question Posted / sanjeev

24 Answers
29760 Views
Mind Tree, I also Faced
E-Mail Answers

Answer Posted / sanjeev

SELECT ENAME FROM TABLE NAME WHERE SAL>(SELECT MAX(SAL)
FROM TABLE NAME GROUP BY DEPTNO

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Are sql database names case sensitive?

954

what are the differences between require and include, include_once and require_once? : Sql dba

985

What is compiled query?

970

What are the rules to be applied to nulls whilst doing comparisons?

1290

Are stored procedures compiled?

884

What is trigger in flip flop?

970

What is difference sql and mysql?

952

what is the difference between join and union? : Sql dba

1057

Is join and inner join the same?

958

How does rowid help in running a query faster?

1380

What is nvl?

1031

what is the difference between undefined value and null value? : Sql dba

1053

Can we insert data into view?

856

What is cursor explain with example?

938

when is the use of update_statistics command? : Sql dba

989