The selected columns are arranged in the order of the column names, as they are specified in the SELECT statement and not as they are stored in the base table.
SELECT firstname, name
FROM customer
An '*' can be used instead of the list of column names. The user receives all the table columns in the order defined in the database.
SELECT *
FROM customer
produces the table 'customer' with all its columns and rows as the result.