DBI202Xuất hiện trong 1 đề thi
Regarding the difference between WHERE and HAVING in SQL, which of the following is true?
Các lựa chọn
AWHERE is used filter data in an SQL query on aggregated values, HAVING is used on non-aggregated ones.
BWHERE is written after GROUP BY, while HAVING comes before GROUP BY.
CWHERE is used filter data in an SQL query on non-aggregated values, HAVING is used on the aggregated ones.
DHAVING and WHERE is written before GROUP BY, while HAVING comes before WHERE.