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

how to drop an existing table in mysql? : Sql dba

1094

What is the trigger in sql?

1004

How sql query is executed?

1189

What are %type and %rowtype for?

1112

How would you convert date into julian date format?

1046

Is sqlite good enough for production?

1049

What is a recursive join sql?

1119

What is Collation Sensitivity ? What are the various type ?

1006

What is union and union all keyword in sql and what are their differences?

1165

Define concurrency control. : Transact sql

1236

How does index help in query performance?

1089

What is rtm stands for?

1178

What is a sql statement?

1020

Why stored procedure is faster than query?

1159

Which type of cursor is used to execute the dml statement?

997