文章列表
选出相同记录的SQL语句是：
select * from tableName where id in (
select id from tableName group by id having count(*) > 1)
删除表中相同的记录中的一条
Delete from table where id not in (select Max(id) from @ Group by sName)
- 2008-09-28 20:58
- 浏览 719
- 评论(0)
------------------------------------------------------------------
来源：CSDN发布会员：新书城收集整理发布时间：2006-10-14人气：148
传统的：
1<beanid="dataSource"destroy-method="close">
2<propertyname="driverClassName"value="oracle.jdbc.driver.OracleDriver"/>
3<propert ...
- 2008-09-28 20:56
- 浏览 918
- 评论(0)