What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 26985 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / ravindran
1.WHERE clause can be used with SELECT,INSERT and UPADATE statements,where as HAVING clause can only be used with the SELECT statements.
2.WHERE filter after rows before aggregation(GROUPING),
where as,HAVING filters groups,after the aggregations are performed.
3.Aggregate functions cannot be used in the WHERE clause,unless it is in a sub query containing in a HAVING clause,where as,aggregate functions can be used in having clause.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What is normalization process?
Can another user execute your local temporary stored procedures?
plss anybody specify tha constrian management system in dbms
Why normalization is used?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What is enhanced database mirroring in sql server 2008?
What is 2nf normalization?
What is subquery? Explain the properties of a subquery?
What is the difference between stored procedure and functions?
What is partition in sql server?
What is key set driven?
What is data mart? : sql server analysis services, ssas
Explain indexed views?
