Return rows in random order

Question

Is it possible to write SQL query that returns table rows in random order every time the query run?

Accepted Answer

```
SELECT * FROM table
ORDER BY NEWID()
```

Solution