SELECT rownum,a.lg_id,a.full_name,a.sort_order FROM activity_type_lang a where a.lg_id = 'en' order by a.full_name;
SELECT row_number() OVER (ORDER BY a.full_name),lg_id,full_name,sort_order FROM activity_type_lang a WHERE a.lg_id = 'en' ORDER BY a.full_name