在MysqL中,查询将如下所示:
SELECT * from tablename ORDER BY RAND() LIMIT 5
上面的查询给出了表中5个随机数的结果.同样的查询如何处理MS sql?
SELECT TOP 5 * from tablename ORDER BY NEWID()
> NEWID()