SELECT clause in Google Sheets - Step-by-Step Guide

Introduction

The SELECT clause in Google Sheets is used inside the QUERY function to choose which columns of data you want to see. It helps you pick only the information you need from a larger table, making your data easier to read and analyze.

When you want to show only the names and prices from a product list without all other details.

When you have a sales table but only want to see the sales amounts and dates.

When you want to create a summary table that includes just specific columns from a big dataset.

When you need to filter out unnecessary columns before sharing data with others.

When you want to rearrange columns by selecting them in a different order.

Steps

Step 1: Click

- a blank cell where you want the result

The cell is ready for you to type a formula

Step 2: Type

- the formula bar

You start entering the QUERY formula

💡 Start with =QUERY(

Step 3: Select

- the range of your data inside the formula

The data range is included in the formula

💡 Example: A1:D10

Step 4: Type

- the formula bar after the range

You add the SELECT clause inside quotes

💡 Example: "SELECT A, C" to pick columns A and C

Step 5: Close

- the QUERY formula with a parenthesis

The formula is complete and ready to run

Step 6: Press

- Enter key

The selected columns from your data appear in the cell and below

Before vs After

Before

A table with columns: Name, Category, Price, Stock with all data visible

After

A new table showing only the Name and Price columns from the original data

Settings Reference

Data range

📍 First argument of QUERY function

Defines which data the QUERY function will look at

Default: None

Query string

📍 Second argument of QUERY function

Specifies which columns to show and how to filter or sort data

Default: None

Headers

📍 Third argument of QUERY function

Tells QUERY how many header rows your data has

Default: 1

Common Mistakes

Using column letters without quotes in the SELECT clause

The QUERY function requires the SELECT clause to be a text string inside quotes

Write the SELECT clause inside double quotes, like "SELECT A, B"

Selecting columns that are outside the data range

QUERY cannot select columns that are not in the specified range, causing errors

Make sure the data range includes all columns you want to select

Forgetting to close the QUERY formula with a parenthesis

This causes a formula error and no result is shown

Always end the formula with a closing parenthesis )

Summary

The SELECT clause in QUERY lets you pick specific columns from your data.

You write the SELECT clause inside quotes, using column letters like A, B, C.

Make sure your data range includes all columns you want to select.

Practice

1. What does the SELECT clause do inside the QUERY function in Google Sheets?

easy

A. It adds new columns to the data.

B. It sorts the data in ascending order.

C. It filters rows based on a condition.

D. It chooses which columns to show from the data.

Solution

1. Step 1: Understand the role of SELECT in QUERY

   The SELECT clause specifies which columns to display from the data range.

2. Step 2: Differentiate from other clauses

   Sorting is done by ORDER BY, filtering by WHERE, and adding columns is not done by SELECT.

3. Final Answer:

   It chooses which columns to show from the data. -> Option D

4. Quick Check:

   SELECT = choose columns [OK]

Hint: SELECT picks columns to show, not rows or sorting [OK]

Common Mistakes:

• Confusing SELECT with WHERE clause
• Thinking SELECT sorts data
• Assuming SELECT adds new columns

2. Which of the following is the correct syntax to select columns A and C using the QUERY function?

easy

A. =QUERY(A1:C10, "SELECT B, D")

B. =QUERY(A1:C10, "SELECT 1, 3")

C. =QUERY(A1:C10, "SELECT A, C")

D. =QUERY(A1:C10, "SELECT A C")

Solution

1. Step 1: Check correct column letters in SELECT

   Columns are referenced by letters like A, B, C. To select columns A and C, use "SELECT A, C" with a comma.

2. Step 2: Verify syntax correctness

   =QUERY(A1:C10, "SELECT A, C") uses correct syntax with comma and column letters. =QUERY(A1:C10, "SELECT 1, 3") uses numbers which is invalid. =QUERY(A1:C10, "SELECT B, D") uses B and D which are wrong columns. =QUERY(A1:C10, "SELECT A C") misses comma between columns.

3. Final Answer:

   =QUERY(A1:C10, "SELECT A, C") -> Option C

4. Quick Check:

   Use column letters with commas in SELECT [OK]

Hint: Use column letters with commas in SELECT clause [OK]

Common Mistakes:

• Using numbers instead of letters for columns
• Omitting commas between columns
• Selecting columns not in the data range

3. Given the data in A1:C4 as:

A | B | C
1 | 2 | 3
4 | 5 | 6
7 | 8 | 9

What will be the output of =QUERY(A1:C4, "SELECT B, C")?

medium

A. 2 3
5 6
8 9

B. B C
2 3
5 6
8 9

C. A B
1 2
4 5
7 8

D. 1 2
4 5
7 8

Solution

1. Step 1: Identify columns B and C data

   Column B values are 2, 5, 8 and column C values are 3, 6, 9 from rows 2 to 4.

2. Step 2: Understand QUERY output format

   QUERY includes headers by default, so output shows header row "B C" followed by data rows.

3. Final Answer:

   B C 2 3 5 6 8 9 -> Option B

4. Quick Check:

   QUERY shows headers and selected columns [OK]

Hint: QUERY outputs headers by default with selected columns [OK]

Common Mistakes:

• Ignoring headers in output
• Selecting wrong columns
• Mixing up row and column data

4. The formula =QUERY(A1:C10, "SELECT A B") returns an error. What is the fix?

medium

A. Add a comma between A and B: "SELECT A, B"

B. Change A and B to numbers: "SELECT 1 2"

C. Remove the SELECT keyword

D. Use lowercase letters: "select a b"

Solution

1. Step 1: Identify syntax error in SELECT clause

   The columns A and B must be separated by a comma in the SELECT clause.

2. Step 2: Correct the syntax

   Adding a comma between A and B fixes the syntax: "SELECT A, B".

3. Final Answer:

   Add a comma between A and B: "SELECT A, B" -> Option A

4. Quick Check:

   Columns must be comma-separated in SELECT [OK]

Hint: Separate columns with commas in SELECT clause [OK]

Common Mistakes:

• Omitting commas between columns
• Using numbers instead of letters
• Removing SELECT keyword

5. You have a table with columns Date (A), Product (B), and Sales (C). You want to use QUERY to show only the Product and Sales columns but sorted by Sales descending. Which formula correctly uses SELECT and ORDER BY?

hard

A. =QUERY(A1:C100, "SELECT B, C ORDER BY C DESC")

B. =QUERY(A1:C100, "SELECT A, B ORDER BY C DESC")

C. =QUERY(A1:C100, "SELECT B, C ORDER BY B DESC")

D. =QUERY(A1:C100, "SELECT B, C ORDER BY A DESC")

Solution

1. Step 1: Identify columns to select

   You want to show Product (B) and Sales (C), so SELECT B, C is correct.

2. Step 2: Sort by Sales descending

   ORDER BY C DESC sorts by Sales column descending.

3. Step 3: Verify full formula correctness

   =QUERY(A1:C100, "SELECT B, C ORDER BY C DESC") correctly combines SELECT and ORDER BY clauses. Other options select wrong columns or order by wrong columns.

4. Final Answer:

   =QUERY(A1:C100, "SELECT B, C ORDER BY C DESC") -> Option A

5. Quick Check:

   SELECT columns + ORDER BY sales DESC = correct [OK]

Hint: Use SELECT for columns, ORDER BY for sorting in QUERY [OK]

Common Mistakes:

• Ordering by wrong column
• Selecting wrong columns
• Missing ORDER BY clause