SQL 行转列

1. 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
1
2
3
4
5
6
7

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
1
2
3
4
5
6
7
8
9
10