Interested to Buy Any Domain ? << Click Here >> for more details...
query to retrive the employees whose sal is greater than avg
sal
- 10 Answers
- 14833 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 to get a list of indexes of an existing table? : Sql dba
What does pragma mean?
What is index example?
What are the triggers associated with image items?
What is the use of prepared statement?
What is difference between sql and oracle?
How can use stored procedures in sql?
How exception is different from error?
What are the popular database management systems in the it industry?
what does the t-sql command ident_incr does? : Transact sql
What does seeding a database mean?
What company owns postgresql?
Do we need commit after truncate?
What is the difference between in and between in sql?
Which is faster union or join?
