Using a function in SQL Server to achieve random sorting of data records in a table [ZT]

If you want to remember the records in a table for random display, or randomly extract a record, we do not need to write a long stringProgramCodeHow can we create a random number and then make a so-called "random record"? You only need to use a small function in SQL Server to implement the random sorting or random extraction function, this function is newid ()

The method is simple. For example, if we want to randomly sort the data in a stuinfo table, we can write the following SQL statement.1Select * FromTb_stuinfoOrder By Newid()

if you want to get a random record, you can perform the following operations: 1 select top 1 * from tb_stuinfo order by newid ()