SELECT
*
FROM
Table1 AS T1
WHERE Id = (
SELECT TOP 1 Id
FROM
Table1 AS T2
WHERE (T2.C2 = T1.C2
AND T2.C3 = T1.C3
)
ORDER BY Id ASC
)
posted on 2008-06-05 14:24  大斌锅  阅读(249)  评论(2)    收藏  举报