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
30197 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

What is dynamic query?

957

What is user defined functions?

955

What is the difference between alter trigger and drop trigger statements?

1092

What is program debugging?

1219

What is sql not null constraint?

1010

what is meant by urlencode and urldocode? : Sql dba

1154

What is difference between stored function and application function?

1173

Is sql database free?

960

What is left join in postgresql?

1029

What are all the common sql functions?

999

What can sql server reporting services do?

1096

Explain the the delete statements in sql?

1042

What is record variable?

961

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3557

Do foreign keys improve performance?

1008