05 2008 档案
摘要：1. 在表中找出指定字段重复记录个数 答案：SELECT [Field1],[Field2],[Field3],[...],COUNT(*) FROM [TableName] WHERE[Condition] GROUPBY [Field1],[Field2],[Field3],[...]HAVING COUNT(*)>12. 表中每个Y的最新X(ID为主健且自增) 答案：SELECTID,Y,X FROM TableName T WHERE (NOTEXISTS(SELECT 1FROM TableName T2 WHERE (T2.Y=T.Y)AND(T2.X>T.XOR T2
阅读全文
