You can have both WHERE and HAVING in a SQL. WHERE - filters before grouping. HAVING - filters after grouping. Example: SELECT id, AVG(salary); FROM tbl_emp ...
確定! 回上一頁