SQL Syntax — Rules, Structure and How to Write SQL Statements

What Is SQL Syntax?

SQL syntax is the set of rules and structure that governs how you write instructions for a database. Think of it as the grammar of SQL — just like English has rules for forming sentences, SQL has rules for forming statements.

Every SQL statement is built from keywords, clauses, expressions, and operators arranged in a specific order. If you break a syntax rule, the database will return an error instead of a result.

Here is a simple example to see SQL syntax in action:

SELECT Name, City
FROM Customers
WHERE City = 'Mumbai'
ORDER BY Name;

+----------------+---------+
| Name           | City    |
+----------------+---------+
| Amit Patel     | Mumbai  |
| Rahul Sharma   | Mumbai  |
+----------------+---------+

This single statement contains four clauses — SELECT, FROM, WHERE, and ORDER BY — each playing a specific role. Let’s break them down.

Structure of an SQL Statement

Most SQL statements follow a predictable structure. Here are the core components:

The SELECT Statement — Most Common SQL Syntax

The SELECT statement is the most frequently used SQL command. You will explore it in depth in Chapter 3: SQL SELECT. Here is its general syntax:

SELECT column1, column2, ...
FROM table_name
WHERE condition
ORDER BY column ASC|DESC;

Let’s use the Employees table from Chapter 1 to see this in practice:

+----+-----------+------------+--------+--------+
| ID | Name      | Department | Salary | City   |
+----+-----------+------------+--------+--------+
| 1  | Priya K.  | Sales      | 55000  | Mumbai |
| 2  | John D.   | Marketing  | 62000  | London |
| 3  | Arun M.   | IT         | 78000  | Delhi  |
| 4  | Emma W.   | Sales      | 51000  | Sydney |
| 5  | Ravi S.   | IT         | 72000  | Mumbai |
+----+-----------+------------+--------+--------+

Example 1 — Select specific columns:

SELECT Name, Department
FROM Employees;

+-----------+------------+
| Name      | Department |
+-----------+------------+
| Priya K.  | Sales      |
| John D.   | Marketing  |
| Arun M.   | IT         |
| Emma W.   | Sales      |
| Ravi S.   | IT         |
+-----------+------------+

Example 2 — Select all columns using *:

SELECT *
FROM Employees;

The asterisk (*) is a shortcut that means “all columns.” It is useful for quick exploration but should be avoided in production queries because it fetches more data than you usually need.

SQL Keywords Are NOT Case Sensitive

One of the most important syntax rules to remember: SQL keywords are not case sensitive. All three statements below are identical and produce the exact same result:

-- UPPERCASE (Recommended Convention)
SELECT Name FROM Employees;

-- lowercase (Also works)
select Name from Employees;

-- Mixed case (Also works)
SeLeCt Name FrOm Employees;

The Semicolon — Statement Terminator

The semicolon (;) marks the end of an SQL statement. It tells the database: “This is a complete instruction — execute it now.”

-- Single statement
SELECT Name FROM Employees;

-- Multiple statements executed together
SELECT Name FROM Employees;
SELECT City FROM Customers;

Some database systems (like MySQL) allow you to omit the semicolon for single queries. However, always include it — it is required when running multiple statements and is considered best practice in all environments.

Single Line vs Multi-Line Statements

SQL does not care about line breaks or extra spaces. A query can be written on a single line or spread across multiple lines. The database sees both versions identically.

Single line (harder to read):

SELECT Name, Department, Salary FROM Employees WHERE Salary > 60000 ORDER BY Salary DESC;

Multi-line (much easier to read):

SELECT Name, Department, Salary
FROM Employees
WHERE Salary > 60000
ORDER BY Salary DESC;

+-----------+------------+--------+
| Name      | Department | Salary |
+-----------+------------+--------+
| Arun M.   | IT         | 78000  |
| Ravi S.   | IT         | 72000  |
| John D.   | Marketing  | 62000  |
+-----------+------------+--------+

SQL Comments

Comments are notes you add to your SQL code for explanation. The database ignores them completely — they exist only for human readers. SQL supports two types of comments:

Single-Line Comments

Use two dashes (--) to comment a single line:

-- This query fetches employees earning over 60K
SELECT Name, Salary
FROM Employees
WHERE Salary > 60000;

Multi-Line Comments

Use /* ... */ to comment across multiple lines:

/*
  Author: PK
  Purpose: Get high-earning employees
  Date: March 2026
*/
SELECT Name, Salary
FROM Employees
WHERE Salary > 60000;

Adding comments to your queries is a highly recommended habit. When you revisit a query weeks later, comments help you instantly understand what the code does and why you wrote it.

Text Values vs Numeric Values

An important syntax rule in SQL is how you handle different data types in your conditions. You will use these rules heavily when learning the SQL WHERE clause in Chapter 5.

Text values must be enclosed in single quotes:

SELECT * FROM Employees
WHERE City = 'Mumbai';       -- ✓ Correct

SELECT * FROM Employees
WHERE Department = 'IT';     -- ✓ Correct

Numeric values do NOT use quotes:

SELECT * FROM Employees
WHERE Salary > 60000;          -- ✓ Correct

SELECT * FROM Employees
WHERE ID = 3;                  -- ✓ Correct

Most Important SQL Keywords

Here are the SQL keywords you will use most frequently throughout this SQL tutorial course. Each one will be covered in detail in upcoming chapters:

For a complete reference of all SQL statements, see the official MySQL SQL statements documentation.

Common SQL Syntax Errors and How to Fix Them

As a beginner, you will encounter syntax errors frequently. Here are the most common mistakes and how to fix them:

Complete SQL Statement Order

When writing a full SQL query, clauses must appear in a specific order. Here is the correct sequence that the database expects:

SELECT    column1, column2      -- 1. What to show
FROM      table_name            -- 2. Where to look
WHERE     condition              -- 3. Which rows to filter
GROUP BY  column                 -- 4. How to group
HAVING    group_condition        -- 5. Filter groups
ORDER BY  column ASC|DESC       -- 6. How to sort
LIMIT     number;                -- 7. How many rows

You won’t always use all seven clauses. A simple query may only need SELECT and FROM. But when you use multiple clauses, they must appear in this order — putting WHERE after ORDER BY, for example, will cause a syntax error.

If you work with data regularly, explore our ready-made Dashboard Templates on NextGenTemplates that use SQL-powered data for business reporting.

📺 Visit our YouTube channel @NeoTechNavigators for step-by-step video tutorials and dashboard demos on this topic.

SELECT Name, Salary
FROM Employees
WHERE Salary > 55000
ORDER BY Salary DESC;

+-----------+--------+
| Name      | Salary |
+-----------+--------+
| Arun M.   | 78000  |
| Ravi S.   | 72000  |
| John D.   | 62000  |
+-----------+--------+

📖 Chapter 2 of 30 — SQL Tutorial on Neotech Navigators