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
29529 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 difference between inner join and self join?

1028

What is cold data?

897

Explain locks? : Transact sql

951

What are %type and %rowtype for?

1012

What is a design view?

886

Why truncate is used in sql?

936

what is isam? : Sql dba

951

How can you create an empty table from an existing table?

1010

How do you optimize a stored procedure in sql?

893

What is the difference between the conventional and direct path loader? : aql loader

1111

what are the advantages of sql ? : Sql dba

999

What normalization means?

905

What are transaction and its controls?

967

What is sql integrity?

1060

what are the advantages of using stored procedures? : Sql dba

1059