表数据:
SQL:
SELECT DATE_FORMAT(last_click_time,'%Y-%m-%d'),GROUP_CONCAT(product_name) from lm_loan_apply GROUP BY DATE_FORMAT(last_click_time,'%Y-%m-%d')
结果:
表数据:
SQL:
SELECT DATE_FORMAT(last_click_time,'%Y-%m-%d'),GROUP_CONCAT(product_name) from lm_loan_apply GROUP BY DATE_FORMAT(last_click_time,'%Y-%m-%d')
结果: