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
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
How can I delete duplicate rows?
What is spool?
What is sql*loader and what is it used for?
What is primary key and foreign key with example?
What does inner join mean?
How is sql used in oracle?
Do stored procedures prevent sql injection?
what are the security recommendations while using mysql? : Sql dba
What does := mean in pl sql?
Can we use join in subquery?
What is the difference between a primary key and a unique key?
how to do backup entire database? : Transact sql
What is indexes?
what is normalization? : Sql dba
Which join is default?