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
19537 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 are packages in pl sql and also explain its advantages?

965

Can a varchar be a primary key?

958

What is composite data type in pl sql?

1037

What does partition by mean in sql?

912

How many joins in sql?

951

what is the difference between blob and text? : Sql dba

965

What are sql*plus environment variables?

1032

Show the cursor attributes of pl/sql.

998

What packages are available to pl/sql developers?

996

what are wild cards used in database for pattern matching ? : Sql dba

1080

What is the purpose of using pl/sql?

1079

What is difference between left and right outer join?

934

what is union, minus and interact commands? : Sql dba

1123

What is the difference between sql and isql*plus?

1009

what is dbms? : Sql dba

934