請教下，SQL如何寫，使多行重復值變成一行，最后如圖輸出A表，謝謝了。
如圖：
uj5u.com熱心網友回復：
沒辦法，sql不是干這個活得。uj5u.com熱心網友回復：
SELECT 'A' AS number,'part1' AS SECTION,1 AS COUNT,0.001 AS weight
UNION ALL
SELECT 'A','part1',2,1.001
UNION ALL
SELECT 'A','part1',3,2.001
;WITH temp(number,SECTION,COUNT,weight) AS
(
SELECT 'A','part1',1,0.001
UNION ALL
SELECT 'A','part1',2,1.001
UNION ALL
SELECT 'A','part1',3,2.001
)
SELECT
CASE WHEN rn=1 THEN number ELSE '' END AS 'number'
,CASE WHEN rn=1 THEN SECTION ELSE '' END AS 'SECTION'
,COUNT,weight FROM (
SELECT *,
ROW_NUMBER() over(PARTITION BY number,SECTION ORDER BY weight) AS rn
FROM temp
) t
uj5u.com熱心網友回復：
你這輸出不也是三行么，就隱藏了第二第三行的序號和部門內容
uj5u.com熱心網友回復：
對，我感覺它文字和圖片描述的不是一回事。。。可能它先要的是圖片的那種吧
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/11438.html
標籤：疑難問題