Random display records in the database

xiaoxiao2021-03-06  41

In MS SQL Server, the record in the database is randomly displayed, which can be written like this.

SELECT TOP 5 ArticleID, Title, URL from Articles ORDER BY NEWID () is used by the newID () function in the MS SQL Server.

转载请注明原文地址:https://www.9cbs.com/read-79105.html

New Post(0)