select salary from eno where salary<(select avg(salary) from eno ) an

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

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

Answer Posted / parth

select salary from eno where salary<(select avg(salary)
from eno ) and rownum < 6

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between inner join and natural join?

1020

What is the difference between syntax error and runtime error?

1148

What is sql partition?

1117

what are the different type of normalization? : Sql dba

1035

Can you load data into multiple tables at once? : aql loader

1082

How does index help in query performance?

1037

Where do we use pl sql?

1007

Determine if oracle date is on a weekend?

1052

Which join is default?

965

What are the different set operators available in sql?

1035

Define a temp table?

1031

What are the datatypes available in pl/sql ?

1116

Can you join a table to itself?

1152

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

1056

What is benefit of creating memory optimized table?

984