sql群組排名

ROW_NUMBER() OVER(PARTITION BY B.客戶編號 ORDER BY B.客戶編號) AS 序號