当前位置：网站首页>If the field lines are the same, they will be merged into another field SQL statement?

If the field lines are the same, they will be merged into another field SQL statement?

2022-04-21 13:33:00 【CSDN Q & A】

As shown in the figure, if the field 1 The columns are the same , Put the corresponding Field 2 Add content to field 3

img

Thank you very much
sqlite mysql Every sentence can be



Take the answer ：

There is a question that needs to be clarified , Field 3 is the result you want, isn't it ？ It's not what it's supposed to be , If so , Then use the following statement to ：

select   Field 1,group_concat( Field 2) from table_name group by  Field 1

If the field 3 There is always , Then we need to use max Take it out , Then associate the subquery with the above statement ,concat Just splice them together .

版权声明
本文为[CSDN Q & A]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204142122441677.html

边栏推荐

猜你喜欢

随机推荐