如何在PostgreSQL查询中显示行号？ [英] How to show row numbers in PostgreSQL query?

问题描述

我想显示一个PostgreSQL查询返回的每条记录的观测数。

我认为在8.4窗口函数中可以执行此功能。

解决方案

 选择row_number（）over（最后由< field& 
 from foo_tbl 
 order by< field> 
  

如果不需要订单，也可以简化此答案：

select row_number（）over（），* - 注意：不需要字段
来自foo_tbl


I'd like to show the observation number for each record returned by a PostgreSQL query.

I think in 8.4 windowing functions can perform this capability.

解决方案

select   row_number() over (order by <field> nulls last) as rownum, *
from     foo_tbl
order by <field>

If order is not necessary, this answer may also be simplified:

select row_number() over(), *  -- notice: no fields are needed
from   foo_tbl

这篇关于如何在PostgreSQL查询中显示行号？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！