web training room for online courses
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

Consulting