SQL Syntax Basics – Complete Beginner's Guide with Examples (2026-27)

✅ What is SQL Syntax?

SQL syntax is the grammar of SQL — the set of rules that defines how SQL statements must be written for the database to understand and execute them correctly. Just like English sentences follow grammar rules, SQL statements must follow syntax rules.

✅ A valid SQL statement has a specific structure, keyword order, and punctuation.

✅ SQL syntax is mostly the same across all databases (MySQL, PostgreSQL, Oracle, SQL Server), with small differences in advanced features.

✅ SQL is not case sensitive for keywords — SELECT, select, and Select are all valid. However, writing keywords in UPPERCASE is the standard convention that makes queries easier to read.

✅ Core SQL Syntax Rules Every Beginner Must Know

✅ Rule 1 – End statements with a semicolon

Every SQL statement ends with a ; (semicolon). This tells the database engine where one statement ends and the next begins.

SELECT * FROM Employees;
SELECT * FROM Products;

✅ Rule 2 – SQL keywords are NOT case sensitive

SELECT, select, and Select all work the same. But always write keywords in UPPERCASE for readability.

✅ Rule 3 – Text values need single quotes

String (text) values in conditions must be wrapped in single quotes. Numbers do NOT need quotes.

-- Correct: text in single quotes
WHERE Department = 'IT'

-- Correct: numbers without quotes
WHERE Salary > 5000

✅ Rule 4 – Whitespace and line breaks are ignored

You can split a SQL query across multiple lines to improve readability. Extra spaces and line breaks are ignored by the database.

-- These two queries are identical:
SELECT Name, Salary FROM Employees WHERE Department = 'IT';

SELECT Name, Salary
FROM Employees
WHERE Department = 'IT';

✅ Rule 5 – Identifiers (table/column names) are case-sensitive in some databases

Table and column names follow the case they were created with. In PostgreSQL, unquoted identifiers are lowercased automatically. In MySQL, table names are case-sensitive on Linux but not on Windows.

✅ Rule 6 – NULL is not a value — use IS NULL / IS NOT NULL

You cannot compare NULL with = or !=. Always use IS NULL or IS NOT NULL.

-- Wrong — returns 0 rows always:
WHERE Email = NULL

-- Correct:
WHERE Email IS NULL

✅ Correct Clause Order in a SQL SELECT Statement

SQL clauses must be written in a strict order. Writing them out of sequence causes a syntax error.

✅ Full SELECT query using all clauses:-

SELECT Department, COUNT(*) AS Total
FROM Employees
WHERE City = 'Pune'
GROUP BY Department
HAVING COUNT(*) > 1
ORDER BY Total DESC
LIMIT 5;

✅ SQL Commands Overview Table

Here is a quick reference of the most important SQL commands every beginner should know:

✅ SELECT – Read / Retrieve Data Syntax

The SELECT statement retrieves data from a table. It is the most commonly used SQL command. See our full SQL SELECT guide for detailed examples.

✅ Syntax:-

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

SELECT * FROM Employees;

SELECT Name, Department, Salary
FROM Employees;

SELECT Name, Salary
FROM Employees
WHERE Department = 'IT'
ORDER BY Salary DESC;

✅ Result — IT employees sorted by salary:-

✅ INSERT INTO – Add New Data Syntax

The INSERT INTO statement adds a new row to a table.

✅ Syntax:-

INSERT INTO table_name (column1, column2, ...)
VALUES (value1, value2, ...);

INSERT INTO Employees (EmployeeID, Name, Department, Salary, City)
VALUES (6, 'VIKRAM', 'IT', 11000, 'Bangalore');

INSERT INTO Employees (EmployeeID, Name, Department, Salary, City)
VALUES
  (7, 'KAVYA',  'HR',    7500, 'Chennai'),
  (8, 'ARJUN',  'Sales', 6000, 'Hyderabad'),
  (9, 'PRIYA',  'IT',    9500, 'Pune');

✅ UPDATE – Modify Existing Data Syntax

The UPDATE statement changes values in existing rows. It always works together with a WHERE clause to target specific rows.

✅ Syntax:-

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

UPDATE Employees
SET Salary = 12000
WHERE Name = 'POOJA';

UPDATE Employees
SET Salary = 15000, City = 'Mumbai'
WHERE EmployeeID = 1;

UPDATE Employees
SET Salary = Salary + 1000
WHERE Department = 'Sales';

✅ DELETE – Remove Data Syntax

The DELETE statement removes rows from a table based on a condition.

✅ Syntax:-

DELETE FROM table_name
WHERE condition;

DELETE FROM Employees
WHERE EmployeeID = 3;

DELETE FROM Employees
WHERE Department = 'Sales';

✅ CREATE TABLE – Create a New Table Syntax

The CREATE TABLE statement defines a new table, its columns, and data types.

✅ Syntax:-

CREATE TABLE table_name (
  column1  datatype  constraint,
  column2  datatype  constraint,
  ...
);

CREATE TABLE Employees (
  EmployeeID  INT           PRIMARY KEY,
  Name        VARCHAR(50)   NOT NULL,
  Department  VARCHAR(50),
  Salary      DECIMAL(10,2),
  City        VARCHAR(50),
  HireDate    DATE
);

✅ DROP TABLE – Delete a Table Syntax

The DROP TABLE statement permanently deletes a table and all its data from the database. This action cannot be undone.

✅ Syntax:-

DROP TABLE table_name;

DROP TABLE Employees;

DROP TABLE IF EXISTS Employees;

✅ SQL Data Types Reference Table

Every column in a SQL table must have a data type that defines what kind of value it can store. Here are the most common SQL data types:

✅ Writing SQL Comments

SQL comments are notes in your code that are ignored by the database engine. Use them to explain your queries — especially useful in shared or complex scripts.

✅ Single-line comment — use --:-

-- This query selects all IT department employees
SELECT * FROM Employees
WHERE Department = 'IT'; -- Only IT rows

✅ Multi-line comment — use /* ... */:-

/*
  Author: Pramod Behera
  Date: 2026-05-26
  Description: Retrieves all active employees in IT with salary above 8000
*/
SELECT Name, Salary
FROM Employees
WHERE Department = 'IT'
  AND Salary > 8000;

✅ Complete Practice Example – From Table Creation to Query

Here is a complete end-to-end SQL example covering CREATE, INSERT, SELECT, UPDATE, and DELETE — all in one sequence. This is how real database work flows:

CREATE TABLE Employees (
  EmployeeID  INT           PRIMARY KEY,
  Name        VARCHAR(50)   NOT NULL,
  Department  VARCHAR(50),
  Salary      DECIMAL(10,2),
  City        VARCHAR(50)
);

INSERT INTO Employees (EmployeeID, Name, Department, Salary, City)
VALUES
  (1, 'ANNI',  'IT',    10000, 'Mumbai'),
  (2, 'POOJA', 'IT',     9000, 'Pune'),
  (3, 'RAJ',   'SALES',  5000, 'Delhi'),
  (4, 'SUJAN', 'HR',     8000, 'Pune'),
  (5, 'MEENA', 'SALES', 12000, 'Mumbai');

SELECT * FROM Employees;

✅ Result:-

SELECT Name, Salary
FROM Employees
WHERE Department = 'IT'
  AND Salary > 9000
ORDER BY Salary DESC;

✅ Result:-

UPDATE Employees
SET Salary = 11000
WHERE Name = 'POOJA';

DELETE FROM Employees
WHERE EmployeeID = 3;

SELECT * FROM Employees
ORDER BY EmployeeID;

✅ Common SQL Syntax Mistakes to Avoid