SQL — различия между версиями

Текущая версия на 18:02, 25 октября 2022

SQL WHERE And HAVING Clauses
#	Use case	WHERE Clause	HAVING Clause
1	Filtering record from the... (based on the specified condition)	Table	Groups
2	Using without GROUP BY Clause	+	-
3	Implements in	ROW operations	COLUMN operation
4	Containing aggregate function	-	+
5	Statements can be using with	SELECT, UPDATE, DELETE	only SELECT
6	Order in respect to GROUP BY Clause	Before	After
7	Row function	single (like UPPER, LOWER etc.)	multiple (like SUM, COUNT etc.)