[SQL]Summing a column while ignoring duplicate records(row_number())


SELECT custid, SUM(amount)
FROM (SELECT t.*,
             ROW_NUMBER() OVER (PARTITION BY custid, transid ORDER BY transid) AS seqnum
      FROM table_1 t
     ) t
WHERE seqnum = 1;
#SQL






你可能感興趣的文章

 筆記、09801 計算機網路概論-第1-B講 Computer Networks and the Internet

筆記、09801 計算機網路概論-第1-B講 Computer Networks and the Internet

[ 筆記 ] JavaScript 進階 08 - new、extends、super、封裝

[ 筆記 ] JavaScript 進階 08 - new、extends、super、封裝

[面試]帆擎/和盛/叡揚/達暉/凱發

[面試]帆擎/和盛/叡揚/達暉/凱發






留言討論