📂 FROM Clause in SQL

Last Updated: 7th January 2026

The FROM clause is used to specify the data source for a query. It tells SQL from which table (or tables) the data should be retrieved.

  • FROM identifies where the data lives
  • Without FROM, SQL does not know which table to read
  • It works together with SELECT

Hinglish Tip 🗣: FROM batata hai — data kis table se lena hai.

🧾 Basic Syntax of FROM

SELECT column_name
FROM table_name;
  • table_name must exist in the database
  • Spelling must match exactly (depending on DB settings)

📄 Selecting Data from a Single Table

SELECT *
FROM students;

Meaning:

  • Read data
  • From the students table

📂 Using Table Aliases in FROM

Aliases give a temporary short name to a table.

SELECT name
FROM students AS s;

Why aliases are used:

  • Shorter queries
  • Better readability
  • Required when using multiple tables (later topics)

🔁 FROM with Multiple Tables

SELECT *
FROM orders, customers;
← PreviousNext →