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
- 15085 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 are character functions in sql?
what is bdb (berkeleydb)? : Sql dba
What is a table?
What is a schema? How is it useful in sql servers?
Show the cursor attributes of pl/sql.
What schema means?
What are some predefined exceptions in pl/sql?
Explain the working of primary key?
Which software is used for pl sql programming?
How do I run a sql script?
how to rename an existing column in a table? : Sql dba
What does the argument [or replace] do?
what are the authentication modes in sql server? : Sql dba
What is trigger and types?
What is database sql?
