2014年2月7日
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 阅读(1705) 评论(0) 推荐(0)