oracle 语句
1、创建索引CREATE INDEX INDEX_NAME ON TABLENAME (COL_NAME) NOLOGGING PARALLEL 4;
2、去重复，然后取一条数据
select * from table where rowid=any(select max(rowid) from table groupby cola) select * from table where rowid in (select max(rowid) from table groupby cola)
页:
[1]