08:15
Unknown
Having:
The HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions.
Syntax:
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
The HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions.
Syntax:
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
Posted in:
SQL Server Tutorial
0 comments:
Post a Comment