frdemo不能用开窗函数吗
可以。
SELECT *, ROW_NUMBER() OVER (PARTITION BY 货主地区 ORDER BY 货主地区) as row_number
FROM 订单