sql-2017-11-09 group by cnt

select * from T_YJ_TJHZ WHERE ZJDF > 100;

SELECT SUM(PF) FROM T_YJ_ZJPF WHERE XX_ID = '1274';

SELECT xx_id, zb_id, pf FROM T_YJ_ZJPF WHERE XX_ID = '1274' ORDER BY TO_NUMBER(ZB_ID);

SELECT t1.cnt, t1.xxid FROM (SELECT COUNT(zb_id) AS cnt, xx_id AS xxid FROM t_yj_zjpf GROUP BY xx_id) t1 WHERE t1.cnt > 75 ORDER BY t1.xxid;