Order by Newid SQL server helps us sort random rows of the results of a query. Read on to find out more. 

At Bobcares, we offer solutions for every query, big and small, as a part of our SQL Server Support Services.

Let’s take a look at how our SQL Server Support Team is ready to help customers with Order by Newid in SQL Server.

How to use Order by newid in SQL server

The order by newid function helps us sort records in a random order in the SQL Server. Furthermore, the newid function generates a random GUID that comes in handy to return randomized rows from a SELECT query.

The return list of a SQL select query consists of random records when we use NEWID() function in the ORDER BY clause of the query. This leads to a SQL query with random sorting in the returning result.

When we use Order by newid in a SELECT query, NEWID() is executed for each row. Then the rows sort as per the random number courtesy of the NEWID(). After that, the SELECT query returns the result as per the remaining clauses in the query.

For instance, suppose we have a table of 3478 rows consisting of Employee details. If we want to select hundred employee details at random from this table, we can run the following query:

SELECT TOP 100 * 
FROM Employees 
ORDER BY NEWID()

In the above example, it returns a result consisting of the top 100 rows after sorting the rows as per the random number given by NEWID(). At the end of the day, NEWID generates a unique identifier that we can use in the ORDER BY clause of a SELECT query to sort random rows in results.

[Need assistance with a different issue? We are available 24/7.]

Conclusion

In a nutshell, our skilled SQL Server Support Engineers at Bobcares demonstrated how to use Order by newid in SQL Server.