Interested to Buy Any Domain ? << Click Here >> for more details...
query to retrive the employees whose sal is greater than avg
sal
- 10 Answers
- 15074 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / viren
since we are using aggregate function AVG, we have to use
GROUP BY, HAVING clause.
select empName, avg(sal) from employees group by sal having
sal > avg(sal) order by empName;
| Is This Answer Correct ? | 4 Yes | 12 No |
Post New Answer View All Answers
How do I view output in sql developer?
Explain exception handling in pl/sql?
Which sorts rows in sql?
What is package in pl sql with an examples?
How to start oracle sql developer?
What is equi join in sql?
What are the rules to be applied to nulls whilst doing comparisons?
What are inner and outer joins examples of both?
Can we create view in stored procedure?
Why do we use procedures?
Does sql full backup truncate logs?
explain what is mysql? : Sql dba
What is a left inner join?
What are all different types of collation sensitivity?
How to fetch alternate records from a table?
