|
1
2
3
4
5
6
7
8
9
10 |
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 (Personname = a.Personname) AND
(Fraction = a.Fraction) AND
(ID < a.ID)))ORDER
BY
Fraction DESC |
原文：http://www.cnblogs.com/macil/p/3539349.html