select sal from demo where sal<(select avg(sal) from demo where eno in

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

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

Answer Posted / prasant

select sal from demo where sal<(select avg(sal) from demo
where eno in (2,3,4));

NOTE:first create table demo and insert all these 5 rows
then run querry.
If any issue call me(PRASANT)

Is This Answer Correct ?

4 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is pl sql package?

1045

What does plv msg allows you to do?

1152

What are tables in sql?

1075

What is the difference between partition and index?

998

Explain the commit statement.

1169

What is the purpose of my sql?

965

Does google use sql?

973

What is user in sql?

1029

Can you skip header records while loading? : aql loader

1062

What is sharding in sql?

996

what is a field in a database ? : Sql dba

1071

What is a schema sql?

1161

Which command is used to delete a trigger?

1342

Can primary key be changed?

915

What is a record in a database?

1073