如何枚举SQL中返回的行?
我想知道是否有可能枚举回来。不是根据任何列的内容,而是产生连续的整数索引。select ?,count(*) as usercount from users group by age返回一些内容:
122122 783 444 422 4222 它用于https://data.stackexchange.com/
解决方案:
尝试:
SELECT ROW_NUMBER() OVER(ORDER BY age) AS RowNumber count(*) as usercount from users group by age
页:
[1]