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

If a cursor is open, how can we find in a pl/sql block?

1167

What is sqlca in db2?

971

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2016

What is a string data type in sql?

1045

what is data control language? : Sql dba

1028

Which query operators in sql is used for pattern matching?

966

What are different types of statements supported by sql?

1165

Explain dml and ddl?

996

What is the sql*loader? : aql loader

1052

What is sql and db2?

1008

How to create an array in pl/sql?

1069

What are the different sql commands?

1073

What is using in sql?

1094

Can unique keys be null?

912

Can we use join in subquery?

1096