# Specifying Columns

List the columns you want after SELECT, in the order you want them, instead of using \*.

Novice · SQL · MySQL · Updated November 16, 2026

By Gregor Dzierzon

Although it is easy to select all columns in a table by simply using the all columns symbol (`*`), in application programming, it is best practice to explicitly list the columns that you want to have included in the result.

```sql
SELECT customer_id
    , company_name
    , country
    , order_id
    , product_name
    , sales_price
    , quantity
FROM customer_orders
ORDER BY customer_id
    , order_id;
```

`ORDER BY` sorts the rows in the result: here by `customer_id`, and then by `order_id` within each customer. Without it, the database may return rows in any order.

**Note:** the columns appear in the result in the order you list them.

![MySQL Workbench running the query with seven named columns: the result grid shows only those columns, in the order they were listed, sorted by customer and then by order](https://fsdtrainingmedia.blob.core.windows.net/public/images/2026/09/2e412eb05f434094896687f6fc8a8c25.png)

## Do it: make the sales team's call sheet

The sales team is calling every customer this week. Their call sheet should list the person to ask for first, then the company, then the phone number, sorted by the person's name so it's easy to find someone.

The `customers` table (the **Tables** tab shows the SQL that makes it) has these rows:

| customer_id | company_name | contact_name | city | phone |
|---|---|---|---|---|
| ALFKI | Alfreds Futterkiste | Maria Anders | Berlin | 030-0074321 |
| ANATR | Ana Trujillo Emparedados y helados | Ana Trujillo | México D.F. | (5) 555-4729 |
| AROUT | Around the Horn | Thomas Hardy | London | (171) 555-7788 |
| BERGS | Berglunds snabbköp | Christina Berglund | Luleå | 0921-12 34 65 |

Your query should give exactly these rows, in this order:

| contact_name | company_name | phone |
|---|---|---|
| Ana Trujillo | Ana Trujillo Emparedados y helados | (5) 555-4729 |
| Christina Berglund | Berglunds snabbköp | 0921-12 34 65 |
| Maria Anders | Alfreds Futterkiste | 030-0074321 |
| Thomas Hardy | Around the Horn | (171) 555-7788 |

**Your job:** change the query in the box so it gives the call sheet.

- Three columns, in this order: `contact_name`, `company_name`, `phone`.
- Every customer: no filter.
- Sort the rows by `contact_name`, A to Z.

Practiced live on the lesson page: write the SQL right there and check it.

## Cheat sheets

- [Choosing Your Columns](https://www.ask-codey.com/cheat-sheets/the-select-statement-simple-select-query-cheat-sheet)

Source: https://www.ask-codey.com/lessons/the-select-statement-specifying-columns
