The SQL grouping is numbered sequentially based on the sequential unique sequence of each group within each set

Select Row_number () over (the partition by Group field order by sort field) as serial number, which shows the sequence number that is not unique within the group,

SELECT * FROM (select Row_number () over (Order by sort field desc) as rowid from table) as table where rowID between (@PageInde X-1) * @PageSize +1 and @PageIndex * @PageSize paged query, can be used for small and medium data sorting,

The SQL grouping is numbered sequentially based on the sequential unique sequence of each group within each set