SQL SELECT Statement
Explained for Beginners

The SQL SELECT statement is the most used SQL command. If you become a data analyst, you will write SELECT queries almost every day.

You use SELECT to retrieve data from databases, inspect tables, filter columns, preview records, analyze metrics, and answer business questions. If SQL is the language of databases, SELECT is the sentence you use most.

What Is the SQL SELECT Statement?

The SQL SELECT statement is used to retrieve data from a database table.

SELECT column_name
FROM table_name;

SELECT customer_name
FROM customers;

This query returns the customer_name column from the customers table.

Why Data Analysts Use SELECT Constantly

Analysts rarely create databases. They mostly ask questions to solve business problems.

Every one of these questions starts with a SELECT statement. For example:

SELECT order_id, customer_id, revenue
FROM orders;

This fetches order-level business data from the database.

SQL SELECT Statement Syntax Breakdown

Here is the core structure of a query:

SELECT column1, column2
FROM table_name;

Let's look at this example:

SELECT name, city
FROM customers;

Selecting Single or Multiple Columns

Selecting a Single Column

Use this when you only need one field. Efficient querying matters.

SELECT email
FROM customers;

Selecting Multiple Columns

To query multiple fields, separate column names using commas.

SELECT name, city, signup_date
FROM customers;

SELECT * in SQL (Selecting All Columns)

In SQL, the asterisk symbol (*) means all columns.

SELECT *
FROM customers;

This returns everything from the table, containing fields such as:customer_id | name | email | city | signup_date | phone | status

Should You Use SELECT *?

Beginners use it constantly. Professionals avoid it unless exploring. Why?

SQL SELECT with Real Business Example

Instead of fetching everything, adopt targeted analyst thinking: pull only the exact columns needed to answer the business question.

SELECT customer_id, name, email, city
FROM customers;

Column Order in SELECT

SQL returns columns in the order you specify. Change order intentionally for readability:

SELECT city, name
FROM customers;

Using Column Aliases with SELECT

Aliases rename columns temporarily in the query output using the AS keyword. This is useful for:

• Dashboards
• Reports
• Stakeholder readability
• Interview clarity

SELECT revenue AS total_revenue
FROM orders;

You can rename multiple columns in the same select query statement:

SELECT
    customer_id AS id,
    revenue AS order_revenue
FROM orders;

SELECT DISTINCT Preview

Sometimes tables contain duplicates.

SELECT city
FROM customers;

To query only unique values, use the DISTINCT keyword:

SELECT DISTINCT city
FROM customers;

SELECT with Expressions & Text Columns

SELECT with Expressions

The SELECT statement can calculate values. Derived calculation column example:

SELECT revenue * 0.18 AS gst_amount
FROM orders;

Derived expressions are highly useful for:

• Taxes
• Discounts
• Commissions
• Derived metrics

Analysts use this constantly.

SELECT with Text Columns

Text values work normally:

SELECT first_name, last_name
FROM employees;

Common Beginner Mistakes

Watch out for these four common errors:

SELECT vs Excel Thinking

Excel users often think: “I can just open everything.”

Databases don’t work like spreadsheets. With SQL, good analysts adopt a goal-oriented mindset and ask: "What exact data do I need?"

That mindset improves:

• Query speed
• Clarity
• Performance
• Business communication

SQL SELECT in Data Analyst Interviews

Interviewers test your basic data selection logic by asking questions like:

SELECT customer_name
FROM customers;

SELECT customer_id, revenue
FROM orders;

SELECT DISTINCT country
FROM users;

Interviewers test:

• Syntax comfort
• Clarity
• SQL fundamentals
• Data selection logic

Real Analyst Workflow Example

Suppose your manager asks: “Show me customer emails for inactive users.”

SELECT customer_id, email, status
FROM customers;

What Comes After SELECT?

Once you understand SELECT, learn:

Practice Questions

Try writing queries for these exercises:

SELECT name FROM employees;

SELECT product_name, price FROM products;

SELECT * FROM orders;

SELECT revenue AS total_sales FROM orders;

SELECT DISTINCT city FROM customers;