02 2014 档案

sql server 查询表某个字段不重复数据
摘要：SELECT TOP (500) ID, Personname, Personcode, Telphone, Fractioninto temp3FROM Records AS aWHERE (LEN(Personcode) = 18 OR LEN(Personcode) = 15) AND (NOT EXISTS (SELECT 1 AS Expr1 FROM Records WHERE (Personname = a.Personname) AND (Fraction > a.Fraction) OR ... 阅读全文
posted @ 2014-02-07 12:04 lixiaojin 阅读(1658) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示