Saved Bookmarks
| 1. |
What Is Having Clause In Apache Tajo? |
|
Answer» The HAVING clause enables you to specify conditions that FILTER which GROUP results appear in the final results. The WHERE clause places conditions on the selected columns, whereas the HAVING clause places conditions on the groups created by the GROUP BY clause. SELECT COLUMN1, column2 FROM table1 GROUP BY column HAVING [ conditions ] select age from mytable group by age having sum(mark) > 200; The HAVING clause enables you to specify conditions that filter which group results appear in the final results. The WHERE clause places conditions on the selected columns, whereas the HAVING clause places conditions on the groups created by the GROUP BY clause. SELECT column1, column2 FROM table1 GROUP BY column HAVING [ conditions ] select age from mytable group by age having sum(mark) > 200; |
|