摘要：
createtabletest (nunumber);insertintotestvalues(1);insertintotestvalues(1);insertintotestvalues(1);insertintotestvalues(2);insertintotestvalues(3);insertintotestvalues(4);-----------------------------... 阅读全文
posted @ 2009-06-25 13:59
蝎
阅读(1097)
评论(0)
推荐(0)
摘要：
WITH TT AS(SELECT *,rownum = row_number() over(partition by [分组字段] order by newid()) FROM 表名)SELECT * FROM TTwhere rownum = 1 阅读全文
posted @ 2009-06-25 11:52
蝎
阅读(1205)
评论(0)
推荐(0)
浙公网安备 33010602011771号