forum

home / developersection / forums / sql server order by random in series

Ask Question
Steilla Mitchel

Student

I completed my post-graduation in 2013 in the engineering field. Engineering is the application of science and math to solve problems. Engineers figure out how things work and find practical uses for scientific discoveries. Scientists and inventors often get the credit for innovations that advance the human condition, but it is engineers who are instrumental in making those innovations available to the world. I love pet animals such as dogs, cats, etc.

Message
Can you answer this question?
Answer

1 Answers

Aryan Kumar

Aryan Kumar

31-Jul-2023

Sure, here is how to order by random in series in SQL Server:

SQL

USE MyDatabase;

SELECT CustomerID, FirstName, LastName
FROM Customers
ORDER BY NEWID();

The NEWID() function returns a unique identifier, which is a random number that is guaranteed to be unique. The ORDER BY clause orders the rows by the NEWID() function, which will sort the rows in a random order.

The NEWID() function is a database-specific function, so it may not be available in all databases. If the NEWID() function is not available, you can use the RAND() function, which returns a pseudo-random number.

The following query is equivalent to the previous query, but it uses the RAND() function instead of the NEWID() function:

SQL

USE MyDatabase;

SELECT CustomerID, FirstName, LastName
FROM Customers
ORDER BY RAND();

The RAND() function is not guaranteed to be unique, so it is possible that the rows will be sorted in the same order every time the query is executed. If you need to ensure that the rows are sorted in a different order every time the query is executed, you can use the NEWID() function.

advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy