我想知道是否有可能枚举回来。不是根据任何列的内容,而是产生连续的整数索引。 ; C" t3 P3 v- Tselect ?,count(*) as usercount from users group by age返回一些内容:/ ]9 o5 `( Z+ A
122 122 783 444 422 4222 它用于https://data.stackexchange.com/) S1 X) e Q+ }5 I8 G& Z. G
7 R9 O. {" d# J解决方案: 2 `8 A9 U8 J* M6 P" F! Z
尝试: 5 P, w# X/ d% |/ |/ \: t( t' R. wSELECT ROW_NUMBER() OVER(ORDER BY age) AS RowNumber count(*) as usercount from users group by age