having.txt

orale培训教材包括了所有的sql说明和实例

--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';