1,178
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
zhpsam109 2003-06-27
- 打赏
- 举报
用distinct关键字!
例如:查看产品共有多少种类(不能重复)
select distinct 种类 from 产品表
例如:查看产品共有多少种类(不能重复)
select distinct 种类 from 产品表
痞子酷 2003-06-26
- 打赏
- 举报
oralce:
delete from table
where rowid not in (select id,max(rowid) from table group by id)
delete from table
where rowid not in (select id,max(rowid) from table group by id)
叶子哟 2003-06-26
- 打赏
- 举报
这个得具体情况具体分析
select * into temp form table1 group by id(你的关键字或是自增量)//或是用临时表
delete from table1
insert into table1 select * from temp
select * into temp form table1 group by id(你的关键字或是自增量)//或是用临时表
delete from table1
insert into table1 select * from temp
hzhxxx 2003-06-26
- 打赏
- 举报
select distinct from tablename
