What is the difference between HAVING clause and the WHERE
clause?
- 7 Answers
- 14467 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinivas
As per my knowledge WHERE is for conditional retrieving but
we cann't use Average Functions in WHERE clause.
HAVING clause can include AVG Functions.
| Is This Answer Correct ? | 20 Yes | 5 No |
Post New Answer View All Answers
Write a sql query to sort on different column name according to the parameters passed in the function?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
How to see existing views in ms sql server?
what is raid? : Sql server database administration
What is default port number for sql server 2000?
Write a sql query to display the current date?
Define Business Edition in SQL Azure?
What is normalization? Explain different forms of normalization?
What happens if null values are involved in comparison operations?
Explain what are sparse columns?
How to create a user to access a database in ms sql server using "create user" statements?
What are the advantages of using cte?
What are user-defined functions (udfs) in sql server?
What is the difference between for xml raw and for xml auto?
Where is trigger in sql server?
