2007年8月22日
slelect top 用法
摘要： SELECT TOP (10) COUNT(*) AS NUM, A.ID FROM TABLE1 AS A INNER JOIN TABLE1 AS B ON A.ID >= B.ID WHERE (A.ACTIVE = 1) AND (B.ACTIVE = 1) GROUP BY A.ID 该Sql语句目的：从T... 阅读全文
posted @ 2007-08-22 15:38 Sangplus 阅读(563) 评论(0) 推荐(0)