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
20329 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 right join sql?

1013

What is sql character function?

1153

What are the disadvantages of file system?

1367

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1208

Mention what plvcmt and plvrb does in pl/sql?

1203

What is a variable in sql?

1056

what are all the common sql function? : Sql dba

1108

What is sql constant?

1104

Define concurrency control. : Transact sql

1236

What is the difference between join and natural join?

984

What is user defined functions?

1031

Define union, minus, union all, intersect ?

1066

What is delimiter in pl sql?

1102

What is materialized view in sql?

959

Why schema is used in sql?

1089