Query.SQL.Text := 'SELECT CNTRY,DIAL_NUM,SUM(FLG) AS CNT
FROM tablename GROUP BY CNTRY ORDER BY DESC CNTRY';
Query.Open;
Query.First;Query.FieldByName('CNTRY').AsString; //拨叫次数最多的区域
Query.FieldByName('CNT').AsInteger; //拨叫次数最多的区域的拨叫次数
FROM tablename GROUP BY CNTRY ORDER BY DESC CNTRY';
Query.Open;
Query.First;Query.FieldByName('CNTRY').AsString; //拨叫次数最多的区域
Query.FieldByName('CNT').AsInteger; //拨叫次数最多的区域的拨叫次数
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货