在Hive中，如何在查询中使用HAVING子句筛选分组后的结果？（）

A.SELECT *FROM table WHERE column =value HAVING condition
B.SELECT *FROM table HAVING column =value GROUP BY condition
C.SELECT *FROM table GROUP BY column HAVING condition
D.SELECT *FROM table GROUP BY column WHERE condition HAVING value