Choose the correct statements about ORDER BY and NULL: - ORDER BY NAME ASC, displays NULLs last - ORDER BY NAME DESC, displays NULLs last - ORDER BY NAME ASC, displays NULLs first - ORDER BY NAME DESC, displays NULLs first Pick ONE or MORE options.
Answer (1)
In SQL, when you use the ORDER BY clause to sort data in a query, handling of NULL values depends on the ordering direction (ASC for ascending or DESC for descending) and can vary based on the SQL database being used.
Here's how NULL values are typically sorted in common SQL databases:
ORDER BY NAME ASC, displays NULLs first : In ascending order, NULL values usually appear first because NULL is considered the lowest possible value.
ORDER BY NAME DESC, displays NULLs last : In descending order, NULL values typically appear last, although this can vary.
ORDER BY NAME ASC, displays NULLs last : This is generally not true unless explicitly specified with a NULLS LAST clause, which is supported by some SQL databases like PostgreSQL.
ORDER BY NAME DESC, displays NULLs first : This isn't typical either and would need explicit instruction with a NULLS FIRST clause if the database supports it.
The correct options based on default behavior (without using explicit clauses like NULLS LAST or NULLS FIRST) would typically be:
ORDER BY NAME ASC, displays NULLs first
ORDER BY NAME DESC, displays NULLs last
So, more than one option is correct depending on default behavior and whether additional clauses are used.
