SV: Onfly, function generated ID for Select Query

No, the result will be ordered by the window functions order clause so no additional ordering is nessesary. You can try this by changing it to OVER(ORDER BY product_name) KR Mikael Från: Durumdara Skickat: den 10 mars 2023 08:41:06 Till: Gustavsson Mikael Kopi

SV: Onfly, function generated ID for Select Query

Hi, Is it something like row_number() you want? https://www.postgresql.org/docs/current/functions-window.html KR Mikael Från: Durumdara Skickat: den 10 mars 2023 8:12 Till: Postgres General Ämne: Onfly, function generated ID for Select Query Dear Members! I'm