Last updated: August 27, 2026.
A query result is a table-shaped set of rows and columns produced by a SQL statement. The order is undefined unless the query includes ORDER BY.
Example result query
SELECT OwnerID, OwnerLastName, OwnerFirstName
FROM AntiqueOwners
WHERE Country = 'USA'
ORDER BY OwnerLastName, OwnerFirstName;Column aliases control display labels, while filtering controls which rows appear. A result can be empty without being an error: it may simply mean no rows match the condition.
Reading results
| Part | Meaning |
|---|---|
| Column | A selected expression with a name and data type. |
| Row | One matching record or computed group. |
| Null | A missing or unknown value, not an empty string or zero. |
| Row count | The number of rows returned or affected. |
For repeatable output, select explicit columns and specify an ordering.
