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
- 18217 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / madhu
select * from emp where sal<(select avg(sal) from emp where
eno in(2,3,4))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql*loader and what is it used for? : aql loader
How many clustered indexes can you have?
What are inner and outer joins examples of both?
How does a covering index work?
What is pl sql in dbms?
Explain ddl statements in pl/sql?
Explain the savepoint statement.
Is left join and outer join same?
How do I write a cron which will run a sql query and mail the results to agroup?
Can we call dml statement in function?
What is the unique index?
Do we need to rebuild index after truncate?
Is primary key always clustered index?
What are the types of operators available in sql?
What is memory optimized table?
