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
- 12 Answers
- 15364 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
What is indexes?
Which data type is a composite type?
how to load data files into tables with 'mysqlimport'? : Sql dba
What are procedures used for?
What is an implicit commit?
In pl/sql, what is bulk binding, and when/how would it help performance?
What view means?
What are the types of sql commands?
What are the different types of constraints?
What do you mean by stored procedures?
What are the types of keys?
What are different types of queries in sql?
What are the different types of a subquery?
Can one improve the performance of sql*loader? : aql loader
What mean sql?
