0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to bypass life's everyday problems with simple tricks

select id, parentid, row_number() OVER (partition by parentid order by id desc) AS ParentIDRowNumber 
from posts where parentid is not null
order by parentid asc, parentidrownumber asc

fork query

edited nov 30 23

created nov 30 23 anonymous