SQL 行转列
- MySQL
mysql换行使用'\n'
SELECT
pic_business_id,
GROUP_CONCAT( '\n类型', ':', pic_med_type_name, ',金额', pic_cost )
FROM
`sl_patient_item_cost`
GROUP BY
pic_business_id
2. Oracle
oracle换行使用CHR( 10 )
SELECT
MEDICAL_RECORD_ID,
IN_NUMBER,
NAME,
REPLACE( wmsys.wm_concat ( CHR( 10 ) || FIEID || ':' || ERRO || ';' ),';,' , ';') as ERRO
FROM
"MR_IN_ERROR"
WHERE FILE_ID = #{fileId}
GROUP BY
MEDICAL_RECORD_ID, IN_NUMBER,NAME
原文地址:https://blog.csdn.net/qq_45861296/article/details/136361860
免责声明:本站文章内容转载自网络资源,如本站内容侵犯了原著者的合法权益,可联系本站删除。更多内容请关注自学内容网(zxcms.com)!