SQL SERVER in randomly sort query results

Server | sorted | Random Translation: SQL SERVER in randomly sort query results


Randomly Sorting Query Results
I randomly sort query results



Q. How can I randomly sort query results?
Q: How can I randomly sort query results?

A. to randomly order rows, or to return X number of randomly chosen rows, you can use the RAND function inside the SELECT statement. but the RAND function is resolved only once for the entire query, so every row will get same value. you can use an order by clause to sort the rows by the result from the NEWID function, as the following code shows:

A: The results records randomly sort, or random returns X records, you can SELECT statement used in the RAND function. But the RAND function in the query only once, so every row will get the same value. Can pass in order by clause NEWID function to the results of the sort method to achieve, code is as follows:

SELECT *
FROM Northwind.. Orders
Order by newid ()

Select top 10 *
FROM Northwind.. Orders
Order by newid ()


Author: Water