The SELECT command retrieves data from a database, storing the returned data in a result table known as the result set.
The provided SQL statement selects the “CustomerName” and “City” columns from the “Customers” table:
| SELECT CustomerName, City FROM Customers; |
The subsequent SQL statement retrieves all columns from the “Customers” table:
| SELECT * FROM Customers; |