常被使用的SQL语句

--删除重复数据

delete from test where id not in( select min([id ]) from test group by [name])

--随机查询N条数据

select top 5 * from usr.Role order by newid()