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

Ads
 

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

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

View Answers

November 18, 2010 at 4:20 PM

Hi,

Both HAVING and WHERE clause used for specifying the search condition in SQL queries.

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. Having Clause is basically used only with the GROUP BY function in a query.

WHERE Clause can be used for specifying the search criteria in SELECT, DELETE, UPDATE statements.

Thanks,

Ads









Related Tutorials/Questions & Answers:
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
What is the difference between IN and BETWEEN, that are used inside a WHERE clause?
Advertisements
Where and Having clause
What is the difference between the >> and >>> operators?
What is difference between TRUNCATE & DELETE
what is the difference between extends and implements
what is the difference between extends and implements
What is the difference between PHP4 and PHP5?
what is the Difference between weblogic and jboss?
What is difference between a PROCEDURE & FUNCTION ?
What is the difference between $message and $$message?
what is the difference between pop and oop
What is the difference between hibernate and spring
What is the difference between a constructor and a method?
What is the difference between a JDK and a JVM?
What is difference between Path and Classpath?
What is difference between the java and javascript?
What is difference between the java and javascript?
What is the difference between JPA and Hibernate?
What is the difference between ereg_replace() and eregi_replace()?
What is the difference between the functions unlink and unset?
What are the difference between abstract class and interface?
What’s the difference between include and require?
what is the difference between distributed application and web application?
What’s the difference between load() and get()?
What is difference between singleton and prototype bean?
What is the difference between JSF, Servlet and JSP?
HOW CN I USE WHERE AND BETWEEN CLAUSE SIMULTANEOUSLY... IN MYSQL
what is difference between objectan primitive? - Java Beginners
what is the difference between productList==null and productList.size()==0
What is the difference between the Boolean & operator and the && operator?

Ads