洛枫学院

代码 复制 - 运行

select s.*  
from (
select *,row_number() over (partition by SortId order by SortOrder) as group_idx 
from LFsoft_News
) s
where s.group_idx = 1