摘要:
createtabletest (nunumber);insertintotestvalues(1);insertintotestvalues(1);insertintotestvalues(1);insertintotestvalues(2);insertintotestvalues(3);insertintotestvalues(4);-----------------------------... 阅读全文
摘要:
WITH TT AS(SELECT *,rownum = row_number() over(partition by [分组字段] order by newid()) FROM 表名)SELECT * FROM TTwhere rownum = 1 阅读全文