-- 用 group by 代替 distinct select row_number() over(order by object_type) rn , object_type from user_objects group by object_type
SELECT ROWNUM, T1.* FROM (select distinct unit from PTITEMBASEINFO t)T1 或者用开窗函数也行
17,082
社区成员
55,236
社区内容
加载中
试试用AI创作助手写篇文章吧