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
What is right join sql?
What is sql character function?
What are the disadvantages of file system?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
Mention what plvcmt and plvrb does in pl/sql?
What is a variable in sql?
what are all the common sql function? : Sql dba
What is sql constant?
Define concurrency control. : Transact sql
What is the difference between join and natural join?
What is user defined functions?
Define union, minus, union all, intersect ?
What is delimiter in pl sql?
What is materialized view in sql?
Why schema is used in sql?