Tag:Group number

  • SQL sort

    Time:2020-11-26

    Sort 1, 2, 2, 2, 3, 4 with the following function: select row_ Number() over (order by field) from table name; 1、 row_number() Values: 1, 2, 2, 2, 3, 4 Sequence: 1, 2, 3, 4, 5, 6 2、rank() Values: 1, 2, 2, 2, 3, 4 Sequence: 1, 2, 2, 2, 5, 6 3、dense_rank() Values: 1, […]