Hi,

i was wrong that this can not be done by select
i don't know that rows can get value from select :)

try this without execute block as previous

select
X2.TAG, X2.ID, X2.ROK
from
(SELECT * FROM XXX A1 ORDER BY A1.TAG) AS X1
LEFT JOIN (SELECT * FROM XXX A2 ORDER BY A2.TAG) X2 ON X2.ID=X1.ID
ROWS (SELECT COUNT(*) FROM XXX)


Karol Bieniaszewski