Select random with Sqlserver (mssql)

Question

What is the correct way to make an unspecified (random) selection using PHP + Sqlserver, since Microsoft queries do not accept ORDER BY RAND() from MYSQL.

Using MYSQLI would be like this:

$sql ="SELECT * FROM Tabela where campo=‘algum'  order by rand()”;

Answer 1

According to this response from the OS, you can use ORDER BY NEWID(), that generates a uuid.

Answer 2

Try to load the random index before and assign it to the string of the command.

<?php

$indiceRandomico = rand(5, 15);

$sql ="SELECT * FROM Tabela where campo=‘algum'  order by ”. $indiceRandomico;

?>