tm5
tag
válasz DS39 #3042 üzenetére
Esetleg:
WITH x AS (select id from ...), basetable AS (SELECT oszlop1, oszlop2, ROW_NUMBER() over(order by oszlop1) rnum from ...)SELECT oszlop1, oszlop2, x.id - basetable.rnumFROM basetable INNER JOIN x ON (...)