我想知道是否有可能枚举回来。不是根据任何列的内容,而是产生连续的整数索引。$ S1 y3 [8 G: M! Q$ B9 [
select ?,count(*) as usercount from users group by age返回一些内容: 3 m1 p; D1 k$ o1 [: H# Q: \# J122 122 783 444 422 4222 它用于https://data.stackexchange.com/7 }' h1 d" f3 A- u: k/ p
; U0 F! u3 ^: T解决方案: 5 u0 ^2 `& _) w' I" l3 A
尝试: ' n+ c. X7 b1 J r7 w0 A' g; V; C7 vSELECT ROW_NUMBER() OVER(ORDER BY age) AS RowNumber count(*) as usercount from users group by age