摘要: 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 阅读(1640) 评论(0) 推荐(0) 编辑