SELECT * FROM (
select *,ROW_NUMBER() over(partition by (first_leve_kind+second_leve_kind+system_name+document_number+document_number+clause_number) order by id desc) AS rn from t_dic_applicable_provisions_problem
) AS u WHERE u.rn=1 and u.app_type=4
sqlserver去重
最新推荐文章于 2023-03-13 18:59:40 发布