What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 26980 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
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
What is join query?
What is awe?
Can two tables have the same primary key?
How to get the definition of a view out of the sql server?
What command must you use to include the not null constraint after a table has already been created?
How can we solve concurrency problems?
Which language is supported by sql server?
What types of replication are supported in sql server?
Determine how to use the inserted and deleted pseudo tables?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
Differentiate sql server reporting services vs. Crystal reports?
What is the difference between lock, block and deadlock? : sql server database administration
What is a virtual table in sql?
What is transaction server isolation?
How self join is different from outer join?
