Free Web Development Online Tutorials, Learn to Code
Learn SQL Database Development, MS SQL Tutorial Online

Having clause, group by, distinct in SQL Tutorial

HAVING clause in SQL was added because the WHERE keyword could not be used with aggregate functions.

Having clause, Group by Example

having clause, group by
SELECT COUNT(Email),Email FROM tbStudent
GROUP BY Email
HAVING COUNT(Email) > 1

Comment
Name
Email
Website
Subscribe
 
Having Clause in SQL Server