有表Test結(jié)構(gòu)如下
ID                   name
1                      aa
2                      bb
3                      cc
4                      dd
5                      aa
6                      ac
7                      cc
8                      df
第一個語句刪除重復的數(shù)據(jù)。但想在重復的數(shù)據(jù)中只保留一條記錄
SQL語句為
delete from test where id not in( select min([id ]) from test group by [name])
第二個語句要求隨機獲得5條數(shù)據(jù)，SQL語句為
select top 5 * from test order by newid()