SELECT dno,sal FROM EMP WHERE sal>ANY(SELECT AVG(sal)

i have a table
eno dno sal
1 10 200
2 10 150
3 10 100
4 20 75
5 20 100

i want to get sal which is less than the avg sal of thri dept.

eno dno sal
2 10 150
3 10 100
4 20 75

Question Posted / mohan

12 Answers
19542 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / mohan

SELECT dno,sal
FROM EMP
WHERE sal>ANY(SELECT AVG(sal)
FROM emp
GROUP BY dno)
ORDER BY dno;

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the difference between myisam static and myisam dynamic? : Sql dba

1003

What are sql ddl commands?

1021

how to start mysql server? : Sql dba

1147

what is 'mysqlcheck'? : Sql dba

960

Compare sql & pl/sql

1053

What is a sql trace file?

981

What is rank function in sql?

965

What is a data definition language?

1032

What is primary key secondary key alternate key candidate key?

982

What is sql analyzer?

964

How do I view a sql trace file?

962

What is synonyms?

1002

What is inner join in sql?

1004

What is data type in database?

935

What is mdf ldf and ndf?

936