Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between HAVING clause and the WHERE
clause?
- 7 Answers
- 16612 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
What is sql server agent and what are the two modes of authentication in sql server?
List out the differences between global and local temp tables in sql server?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is a linked server in sql server?
How to insert and update data into a table with "insert" and "update" statements?
How use inner join in sql server?
What is delete query?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What is the difference between grant and with grant while giving permissions to the user?
Does sql server 2000 full-text search support clustering?
Distinguish between nested subquery and correlated subquery?
what method you can use to reduce the overhead of Reporting Services data sources?
why would you use sql agent? : Sql server database administration
When would you use the stored procedures or functions?
