select distinct prpdid,subprodid from table;
解决方案 »
- 请哪位大虾帮帮忙看看是什么原因啊!
- 如何制造重复数据
- VB的ADO对象+ODBC对oracle插入数据错误
- shell导出查询结果
- 更改表空间的问题。请教高手,不胜感谢
- CREATE DATABASE的简单问题,帮忙!
- 刚装上的oracle9i,用默认的DBA账号登录,出现ORA-01031:insufficient privilege错误??
- 如何使用sql文中的case?
- 为什么session只有30个
- sqlldr 报错SQL*Loader-350: 语法错误位于第 4 行。
- 简单问题,新手百分求救,为什么我不能直接imp oracle7-oracle9i呢?
- 本人想了解下oracle。。请各位大侠介绍一两本书来看看吧
-------- --------
1 2
1 3
2 5
2 mmSQL> select a.n1,a.n2 from
2 (select aa.*,row_number()
3 over(partition by n1 order by n2) top1 from aa) a
4 where a.top1 <= 1
5 /N1 N2
-------- --------
1 2
2 5
A.ROWID != (SELECT MIN(ROWID) FROM TABNAME B WHERE A.prpdid = B.prpdid)
select prpdid,MIN(subprodid) from tabn
group by "prpdid";
A.ROWID != (SELECT MIN(ROWID) FROM TABNAME B WHERE A.COL1 = B.COL2
AND A.COL2 = B.COL2 AND ..... )
我想着就是你要的东东.
A.ROWID != (SELECT MIN(ROWID) FROM TABNAME B WHERE A.prpdid = B.prpdid )
prpdid subprodid
A 111
B 222
B 333
C 444
D 555
D 666delete from t4 a where a.rowid>(select min(b.rowid) from t4 b where a.prpdid=b.prpdid);
prpdid subprodid
A 111
B 222
C 444
D 555
select row_number() over (partition by prpdid order by subprodid) rn ,tab.*
from tab )
where rn=1
(select TableName.*,row_number()
over(partition by prpdid order by subprodid) rn from TableName) tmp
where tmp.top1 = 1
WHERE subprodid NOT IN
(SELECT MIN(subprodid) FROM AA GROUP BY prodid)
用着那么麻烦了吗
langmanhufei() 、wangybyangxr(王永斌)方法皆可行