GROUP_CONCAT(F01)和GROUP BY配合使用,将每组中的某一栏位数据显示出来
SELECT GROUP_CONCAT(F01) FROM s61.t6111 WHERE F03 IS NOT NULL AND F03 != '' GROUP BY F03 HAVING COUNT(1)>=6;
GROUP_CONCAT(F01)和GROUP BY配合使用,将每组中的某一栏位数据显示出来
SELECT GROUP_CONCAT(F01) FROM s61.t6111 WHERE F03 IS NOT NULL AND F03 != '' GROUP BY F03 HAVING COUNT(1)>=6;