Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

interview

Home Interviews What is the difference between a "where" clause and a "having" clause? – MindStick
Ask Question

1 Answers

Amit Singh
Amit Singh 30 Oct 2010
Report Abuse
Difference between a Where Clause and a Having Clause
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.
Syntax
Having Clause: 

SELECT column_name, aggregate_function(column_name)

FROM table_name

WHERE column_name operator value

GROUP BY column_name

HAVING aggregate_function(column_name) operator value

Where Clause

SELECT column_name(s)

FROM table_name

WHERE column_name operator value
advertising
Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md