select e.eno,e.dno,e.sal from emp_t e, (select dno,avg(sal) avgsal from e

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 / subbu

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

Answer Posted / subbu

select e.eno,e.dno,e.sal
from emp_t e,
(select dno,avg(sal) avgsal from emp_t group by dno) b
where e.sal<b.avgsal and e.dno=b.dno
/

Is This Answer Correct ?

5 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you explain an index number?

1185

Mention what does the hierarchical profiler does?

1140

What operators deal with null?

1154

What is sql key?

1045

Can we delete column in sql?

1173

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

2165

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

1154

Are sql connections encrypted?

1086

Differentiate between syntax and runtime errors.

1242

How do I debug a stored procedure?

1171

Why having clause is used in sql?

1020

How do I view tables in sql developer?

1009

Is record in pl sql?

1013

what is the difference between $message and $$message? : Sql dba

1040

Do foreign keys improve performance?

1068