摘要： http://stackoverflow.com/questions/3959692/rownum-in-postgresqlSELECT row_number() OVER (ORDER BY col1) AS i, e.col1, e.col2, ... FROM... 阅读全文