Shulou(Shulou.com)06/01 Report--

This article is about how sql implements random sorting. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Random ordering

SELECT * FROM TestTable ORDER BY NEWID ()

It can also be combined with TOP to take the first N random records.

SELECT TOP 100 * FROM TestTable ORDER BY NEWID () Thank you for your reading! This is the end of the article on "how to achieve random sorting in sql". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.