本文介绍了一个复杂的SQL查询案例，该查询使用了多个SQL技巧，包括使用变量进行行号标记、GROUP_CONCAT聚合函数以及条件筛选等，展示了如何从特定表中获取格式化的数据。
SELECT GROUP_CONCAT(a.DESCRIPTION SEPARATOR '\n')
FROM (SELECT (@rowNum:=0) AS rowNo,CONCAT('公司内部来文：','\n',
GROUP_CONCAT((@rowNum:=@rowNum+1),DESCRIPTION,CHAR(13),'\n' SEPARATOR '\n')) DESCRIPTION
FROM pj_pro_receive_file_t
WHERE receive_file_type = (
SELECT lookup_code_id FROM fnd_lookup_code_t WHERE lookup_type = 'RECEIVE_FILE' AND lookup_code = 'NBLW')
FROM (SELECT (@rowNum:=0) AS rowNo,CONCAT('公司内部来文：','\n',
GROUP_CONCAT((@rowNum:=@rowNum+1),DESCRIPTION,CHAR(13),'\n' SEPARATOR '\n')) DESCRIPTION
FROM pj_pro_receive_file_t
WHERE receive_file_type = (
SELECT lookup_code_id FROM fnd_lookup_code_t WHERE lookup_type = 'RECEIVE_FILE' AND lookup_code = 'NBLW')
AND project_id = 173 AND receive_status = '1' AND DATE_FORMAT(creation_date, '%Y-%m-%d') = DATE_FORMAT(NOW(), '%Y-%m-%d')) a;
java需要转译@rowNum\\:=0
扫一扫
1892
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
