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;
温馨提示: 本文由Jm博客推荐，转载请保留链接: https://www.jmwww.net/SQL/22238.html
