Answer / guest

Having Clause is basically used only with the GROUP BY
function in a query. WHERE Clause is applied to each row
before they are part of the GROUP BY function in a query.

Answer / srinivas

HAVING CLAUSE is used for evaluating a condition with an
aggregate function, i.e., GROUP BY whereas WHERE CLAUSE is
used for general conditions.

Answer / manisha

Having clause is used to filter group while WHERE CLAUSE
is used to filter rows.
Having clause can have aggregate function but WHERE CLAUSE
cannot have aggregate function.

Answer / menagadev

The HAVING clause sets conditions on the GROUP BY clause
similar to the way WHERE interacts with SELECT. The WHERE
search condition is applied before the grouping operation
occurs; the HAVING search condition is applied after the
grouping operation occurs. The HAVING syntax is exactly
like the WHERE syntax, except HAVING can contain aggregate
functions.

Answer / swati mandve

where clause is executed (for each row) first and
written before the group by statement..
having clause is strictly folllowed by groupby clause.to
filter the group.

Answer / sararh

where clause uesd for the fiend out particulater records and
where clause u write after select statement.

Having clause used for combination of group by functions
with out group by function u can nit write the having caluse.

Answer / 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.

Answer / santosh pashupatimath

Having clause is used before aggregation and where clause is
used before aggregation

Answer / saisri

Where clause is used prior the grouping of data,
where as Having is used after grouping the result of the
data.

Answer / sudheer gowlikar

Having clause 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.

Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  

How is foreign key related to primary key?

0 Answers  

What are the different types of backups avaialabe in sql server 2005?

0 Answers  

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

0 Answers  

Define indexes?

0 Answers  

What is bcnf normalization form?

0 Answers  

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

What is sql language?

0 Answers  

what are constraints? : Sql server database administration

0 Answers  

Can a table have 2 foreign keys?

0 Answers  

What is the maximum row of a size?

0 Answers  

How to run queries with sql server management studio express?

0 Answers