MS SqlServer 随机查询并随机排序

MS SqlServer :

select top N *

from Table1

order by NewId()

mySql:

SELECT * FROM tableName ORDER BY rand()