select ID NAMEfrom BIZ_DOC_RULES拼接ID和NAME
To concatenate the ID and NAME columns in the BIZ_DOC_RULES table, you can use the CONCAT() function in SQL. The SQL query would be:
SELECT CONCAT(ID, ' ', NAME) AS CONCATENATED_ID_NAME FROM BIZ_DOC_RULES;
This query will return a result set with a single column named CONCATENATED_ID_NAME, which contains the concatenation of the ID and NAME values for each row in the BIZ_DOC_RULES table.
原文地址: https://www.cveoy.top/t/topic/i5ZW 著作权归作者所有。请勿转载和采集!