SELECT t3.*,COUNT(0) AS today_num
FROM
(SELECT t1.* FROM `tbl_syrk_capture_compare_30w` t1 WHERE fcmp_time >= 1513367070 AND fcmp_time <= 1513369570 GROUP BY t1.person_id )
t3 GROUP BY t3.id_numb ORDER BY UUID
这样的语句java api该怎么实现
SELECT t3.*,COUNT(0) AS today_num
FROM
(SELECT t1.* FROM `tbl_syrk_capture_compare_30w` t1 WHERE fcmp_time >= 1513367070 AND fcmp_time <= 1513369570 GROUP BY t1.person_id )
t3 GROUP BY t3.id_numb ORDER BY UUID
这样的语句java api该怎么实现
1 个回复
novia - 1&0
赞同来自: