What is the difference between HAVING clause and the WHERE
clause?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ishika
Having clause works on recordset while Where works on
individual record
Is This Answer Correct ? | 15 Yes | 4 No |
Answer / chandra kanth
WHERE is for conditional retrieving and having is using
group of records
Is This Answer Correct ? | 13 Yes | 4 No |
Answer / senthil kumar t
Where clause is used for conditional retreiving from the
table and also aggregate functions can be used in where
clause. Having clause will be used for the recordset this
also supports the aggregate functions
Is This Answer Correct ? | 10 Yes | 4 No |
Answer / pallavi tiwari
in where clause the data that fetched in memory is according
to condition but in having the completed data firstly
fetched in memory and then seperated according to condition.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / vivek kumar
where clause is used for conditional retriving but having
clause is used to test some condition on the group with the
help of aggregate function.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mayursinh zala
'Where' clause applies to the individual rows whereas 'Having' clause is used to test some condition on the group(usually aggregate methods) rather than on individual rows.
Specifies a search condition for a group or an aggregate. HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause.
So you can use having WITHOUT group by clause. This is a sample, although it might make no sense of business value:
select max(state) from States having count(State) > 60
Is This Answer Correct ? | 0 Yes | 0 No |
How to generate create table script on an existing table in ms sql server?
Which sql server is best?
How to drop an existing schema in ms sql server?
How do I port a number to sql server?
How many index keys possible for a table
What are the differences between having and where clause.
What is 4nf in normalization form?
Can we store videos inside the sql server table?
Does partitioning help performance?
How to provide default values to stored procedure parameters?
what is normalization? : Sql server database administration
Explain some DBCC commands?