having.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 14 行

--HAVING 子句TEST
select sum(FIELD2) from sm_group
GROUP BY FIELD1
HAVING FIELD1>'A';

select sum(FIELD2) from sm_group
GROUP BY FIELD1
HAVING MAX(FIELD3)>'05_9月_99';

select sum(FIELD2) from sm_group
GROUP BY FIELD1
HAVING FIELD3>'05_9月_99';