subject:"first order by then partition by x < a fixed value."

Re: first order by then partition by x < a fixed value.

2022-07-14 Thread Frank Streitzig

Am Thu, Jul 14, 2022 at 01:23:55PM +0530 schrieb jian he: > This question (https://stackoverflow.com/q/72975669/15603477) is fun. > DB fiddle link: > https://dbfiddle.uk/?rdbms=postgres_14&fiddle=36d685ad463831877ae70361be2cfa3b > > account > size idname 1001 John 2002 Mary 30

first order by then partition by x < a fixed value.

2022-07-14 Thread jian he

This question (https://stackoverflow.com/q/72975669/15603477) is fun. DB fiddle link: https://dbfiddle.uk/?rdbms=postgres_14&fiddle=36d685ad463831877ae70361be2cfa3b account size idname 1001 John 2002 Mary 3003 Jane 4004 Anne1005 Mike 6006 Joanne T