如何枚举SQL中返回的行？ [英] How to enumerate returned rows in SQL?

问题描述

我想知道是否有可能枚举返回的行。不根据任何列的内容，而只是产生一个连续的整数索引。例如，

I was wondering if it would be possible to enumerate returned rows. Not according to any column content but just yielding a sequential integer index. E.g.

select ?, count(*) as usercount from users group by age

将返回以下内容：

1    12
2    78
3     4
4    42

表示 https://data.stackexchange.com/

推荐答案

尝试：

SELECT
    ROW_NUMBER() OVER(ORDER BY age) AS RowNumber
        ,count(*) as usercount 
    from users 
    group by age

这篇关于如何枚举SQL中返回的行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！