oracle无主键去重方法

select emp_no,dept_code,name from
(
select
b.emp_no,b.dept_code, b.name,
row_number() over(partition by name order by name desc)a from staff_dict b)
where a>=2

 

 

select vsize('汉') from dual;

select userenv('language') from dual;