SELECT A.HYPERION_CODE,A.CITY,A.OPEN_DATE,
ROW_NUMER=NTILE(1000) OVER (partition BY city order by city)
FROM T_AM_BASIC_INFO A
---- NTILE()组内排序
---- OVER (partition BY city order by city) 不懂
SELECT A.HYPERION_CODE,A.CITY,A.OPEN_DATE,
ROW_NUMER=NTILE(1000) OVER (partition BY city order by city)
FROM T_AM_BASIC_INFO A
---- NTILE()组内排序
---- OVER (partition BY city order by city) 不懂