What is the significance of the ORDER BY clause in the provided SQL query?

The ORDER BY clause in an SQL query is used to sort the results based on a specified column or columns in either ascending or descending order. In the provided SQL query, the ORDER BY clause is necessary to ensure that the results are returned in a specific order, such as alphabetically by name or numerically by age. Without the ORDER BY clause, the results would be returned in an arbitrary order, which may not be useful for the intended purpose. 

$sql = "SELECT * FROM users ORDER BY name ASC";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    while($row = mysqli_fetch_assoc($result)) {
        echo "Name: " . $row["name"]. " - Age: " . $row["age"]. "<br>";
    }
} else {
    echo "0 results";
}

Keywords

SQL query ORDER BY clause significance PHP sorting

Related Questions