Where vs having in sql?

Question

Could someone tell me what is the difference between where and having clause in SQL?

Answer 1

The difference between the two clauses is that having clause could be used with aggregate data while the where data couldn’t be used with the aggregate data.

Are you eager to learn SQL? Get yourself certified with SQL certification from Intellipaat which is co-created with Microsoft.

Do watch our video on SQL to get started with the training.