如何在SQL中用group by组合名和姓作为全名

Question

我想在SQL中用group by连接名和姓作为全名。

示例:显示customerNumber, amount(total by customerNumber from tbl_payment)， fullName(firstName， ' '， lastName) from tbl_customers

我已经研究过了，但是没有得到我想要的。

Answer 1

连接FIRSTNAME和LASTNAME列FULLNAMESQL查询GROUP BY条款:-

SELECT 
CUSTOMERNUMBER, 
SUM(AMOUNT) AS TOTAL, 
CONCAT(FIRSTNAME, ' ', LASTNAME) AS FULLNAME
FROM TBL_CUSTOMERS
GROUP BY CUSTOMERNUMBER, FIRSTNAME, LASTNAME;