各位老师,我从数据库多个表里查出的结果出现好多重复的证件号码,请问有什么办法过滤掉这些重复的记录吗?这是我查询用的语句,谢谢各位!select a.*,b.mingcheng,c.mingma,d.mingcheng as mch,e.mingcheng as pl,f.DFMingCheng as zj from Tbl_checkIn a,tbl_diqu b,tbl_ShouPiao c,tbl_YanPiaoDian d,tbl_PiaoLei e,Tbl_SFZ f where ZhengJian a.diqu=b.bianhao and a.KaHao=c.kahao and a.CheckInNo=d.bianhao and left(a.zhengjian,6)=f.SFZBianHao and a.piaolei=e.bianhao and mingma>='008000500002547' and mingma<='008000500002555' order by ZhengJian
解决方案 »
- 急求一段sql,请大神们帮忙……
- 请问一条SQL语句的性能问题
- 一个关于OpenDataSource的问题
- 20w条怎么导入呀
- 祝大家新年好!一个关于numeric数值型数据对比的问题?
- sqlserver 容量的问题-最多支持多大的数据库?高手来发表一下意见
- 数据库插入问题
- 《数据库系统概论》(第四版)——(王珊、萨师煊编著)第二章课后题?
- 我的98 sql client找不到server, 我是按照sqlenumerator中的程序进行修改的
- Foxpro或Sql中的日期时间型如何转换为日期型?
- 有关分类信息发布系统数据库设计的问题??急
- 如何用Java将串口发送的数据保存到SQL Server数据库中
如果有多表,表之间如何关联?
发帖注意事项
http://topic.csdn.net/u/20091130/21/fb718680-98ff-4afb-98d8-cff2f8293ed5.html?24281
a.*,b.mingcheng,c.mingma,d.mingcheng as mch,e.mingcheng as pl,f.DFMingCheng as zj from
Tbl_checkIn a,tbl_diqu b,tbl_ShouPiao c,tbl_YanPiaoDian d,tbl_PiaoLei e,Tbl_SFZ f where
ZhengJian a.diqu=b.bianhao
and
a.KaHao=c.kahao
and
a.CheckInNo=d.bianhao
and
left(a.zhengjian,6)=f.SFZBianHao
and
a.piaolei=e.bianhao
and
mingma>='008000500002547'
and
mingma<='008000500002555'
and
a.checkintime=(select max(checkintime) from tb1_checkIn where kahao=a.kahao)
order by
ZhengJian
a.*,b.mingcheng,c.mingma,d.mingcheng as mch,e.mingcheng as pl,f.DFMingCheng as zj from
Tbl_checkIn a,tbl_diqu b,tbl_ShouPiao c,tbl_YanPiaoDian d,tbl_PiaoLei e,Tbl_SFZ f where
a.diqu=b.bianhao
and
a.KaHao=c.kahao
and
a.CheckInNo=d.bianhao
and
left(a.zhengjian,6)=f.SFZBianHao
and
a.piaolei=e.bianhao
and
mingma>='008000500002547'
and
mingma<='008000500002555'
and
a.checkintime=(select max(checkintime) from tb1_checkIn where kahao=a.kahao)
order by
ZhengJian