bonjour,



WITH TMP as (
select marque, modele, row_number() over(partition by marque order by modele) as rnk
from ma_table)

select marque, modele
from tmp