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
- 18234 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / vin
select * from emp group by deptno having sal < avg(sal)
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How to make a copy values from one column to another in sql?
How do I run a program in pl sql?
What is the use of nvl function?
What is a behavioral trigger?
What is auto increment feature in sql?
Why truncate is used in sql?
How long it takes to learn pl sql?
What do you understand by pl/sql cursors?
Can sql function call stored procedure?
What are stuff and replace function?
how to convert numeric values to character strings? : Sql dba
How can we link a sql database to an existing android app?
How do I pipe the output of one isql to another?
Can we create foreign key without primary key?
What is sql clause?
