在线等11111111111111111111111111111111111111111sqlMySQL急用新人在线等
解决方案 »
- pgpoolⅡ提供给前端的Ip port database user password JDBC怎么连接
- mysql查询问题
- mysql 分组 sum 求助 急!!!!
- 请问该sql该如何处理好 ?
- MYSQL 选用InnoDB 代替MyISAM 会有什么负面影响?
- 一直想问一个问题MYSQL 查询语句问题
- 把SQLserver 的数据传换到 mysql的数据库里出现乱码
- SQL取得剛增加的主鍵值!!!!
- java.sql.SQLException: Invalid argument value, message from server: "Duplicate entry '1' for key 1"
- 数据库表 订单设计
- tinyint范围
- mysql数据库文件存放在哪里?
delete from people where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1) and rowid not in (select min(rowid) from people group by peopleId having count(peopleId )>1) (2)删除表中多余的重复记录(多个字段),只留有rowid最小的记录delete from vitae a where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1) and rowid not in (select min(rowid) from vitae group by peopleId,seq having count(*)>1)
where userId in (select userId from Inst_PlayerArenaRank group by userId having count(userId) > 1 )
and id not in
(select id from Inst_PlayerArenaRank group by userId having count(userId)>1) 把这个帮忙改一下 大哥们
id自增长
userid用户名
select * from Inst_PlayerArenaRank where id in (select min(id) from user group by userid);删除的也很简单,删除用户名重复的,值保留id最小的:
delete from Inst_PlayerArenaRank where id not in(
select a.id from (
select min(id) as id from Inst_PlayerArenaRank group by userid
) a
);
参考一下这个贴子的提问方式http://bbs.csdn.net/topics/320211382
1. 你的 create table xxx .. 语句
2. 你的 insert into xxx ... 语句
3. 结果是什么样,(并给以简单的算法描述)
4. 你用的数据库名称和版本(经常有人在MS SQL server版问 MySQL)
这样想帮你的人可以直接搭建和你相同的环境,并在给出方案前进行测试,避免文字描述理解上的误差。