adspace


What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?

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

Is This Answer Correct ?    35 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to provide default values to function parameters?

1273


What is sql server query analyzer?

1137


What is an indexed view?

1030


What is in place upgrade in sql server?

1137


what is the Ticketing tool used in Wipro technologies at Bangalore...???

8239


What is sql or structured query language?

1235


Disadvantages of the indexes?

1232


How to enter binary string literals in ms sql server?

1256


Equi join and non equi join is possible with sql server?

1140


Can sql servers link to other servers like oracle?

928


If any stored procedure is encrypted, then can we see its definition in activity monitor?

1083


What is clustered index

1094


What is acid mean in sql server?

1257


what is the difference between openrowset and openquery?

1208


What are the source of constraints?

1015