CREATE TABLE `wsz` (
`name` char(2) NOT NULL,
`money` int(11) NOT NULL,
`time` date NOT NULL,
KEY `name` (`name`,`money`,`time`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;#
# 导出表中的数据 `wsz`
#INSERT INTO `wsz` (`name`, `money`, `time`) VALUES ('a', 10, '2011-05-01'),
('a', 10, '2011-06-01'),
('a', 10, '2011-06-01'),
('a', 5, '2011-06-01'),('b', 6, '2011-06-01'),
('b', 20, '2011-06-01'),('c', 0, '2011-06-01'),
('c', 10, '2011-06-01');--------------
取出同一时间出现过二次的name(重复的),并且money也相同的记录
结果:a 10 2011-06-01
a 10 2011-06-01
`name` char(2) NOT NULL,
`money` int(11) NOT NULL,
`time` date NOT NULL,
KEY `name` (`name`,`money`,`time`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;#
# 导出表中的数据 `wsz`
#INSERT INTO `wsz` (`name`, `money`, `time`) VALUES ('a', 10, '2011-05-01'),
('a', 10, '2011-06-01'),
('a', 10, '2011-06-01'),
('a', 5, '2011-06-01'),('b', 6, '2011-06-01'),
('b', 20, '2011-06-01'),('c', 0, '2011-06-01'),
('c', 10, '2011-06-01');--------------
取出同一时间出现过二次的name(重复的),并且money也相同的记录
结果:a 10 2011-06-01
a 10 2011-06-01
from wsz w
where 1<(select count(*) from wsz where name=w.name And money=w.money and `time`=w.`time`)