What is the difference between HAVING clause and the WHERE
clause?
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
Why do we backup Active Directory ?
What is PROJECTION Operation?
How many ways to create table-valued functions?
How can we get count of the number of records in a table?
Can we use pragma autonomous_transaction in trigger?
Which language rdl files made of?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What is Cross Join and in which scenario do we use Cross Join?
Do you know what is difference between stored procedure and user defined function?
How to use copy and concatenate commands in SQL?
What is ms sql server reporting services?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What are the types of sql server?
what is the different types of backups available in sql server? : Sql server database administration
How to list all field names in the result set using mssql_field_name()?