wiki:Count rows

Version 1 (modified by cedric, 13 years ago) (diff)

--

select ouv_id,

row_number() OVER (PARTITION BY ouv_id) as num

from ouvrage....