select whr.id,
concat('01-07-' , whr.stock_location) as location,
whr.stockkeepingunit_id,
whr.articlenumber,
whr.quantity,
whr.lock_quantity
from warehouserecord whr
where LENGTH(stock_location) = 8 concat('01-07-' , 字段) as 别名
sql查询 ,多行数据合并成一行,并且显示合并后某一列的值拼接结果
最新推荐文章于 2024-05-27 15:15:45 发布