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;
TIA
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
使用分析功能也可以更容易地改变如何处理关系.您可以用RANK或DENSE_RANK替换ROW_NUMBER.
