SQL查询数据库中重复的数据
摘要:
select a.mobel,COUNT(a.mobel) as '出现次数' from CustomerData.dbo.VeryImporntPerson_2 a where --CustomerData.dbo.VeryImporntPerson_2 要查询的表的a.id > (select min(b.id) from CustomerData.dbo.authors1 b where b.mobel = a.mobel and --CustomerData.dbo.authors1 要比较的数据表 b.area='江苏-南京' and a.are 阅读全文
posted @ 2013-05-17 10:30 骑蟋蟀的蝈蝈 阅读(217) 评论(0) 推荐(0)
浙公网安备 33010602011771号