摘要: 1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断select*frompeoplewherepeopleIdin(selectpeopleIdfrompeoplegroupbypeopleIdhavingcount(peopleId)>1)例二:select*fromtesttablewherenumeber in (selectnumberfrompeoplegroup bynumberhaving count(number) > 1 )可以查出testtable表中number相同的记录2、删除表中多余的重复记录,重复记录是根据单个字段(people 阅读全文
posted @ 2013-11-20 14:43 无处安放的青春 阅读(233) 评论(0) 推荐(0) 编辑
摘要: 特效网:http://www.xwcms.net1.图片拖动特效http://www.xwcms.net/js/tpdm/32946.html2.弹出层焦点图特效:http://www.xwcms.net/js/tpdm/20571.html3.标题悬停效果动画SVG图标http://www.xwc... 阅读全文
posted @ 2013-11-20 14:37 无处安放的青春 阅读(440) 评论(0) 推荐(0) 编辑