SQLearnAcademy

← Learn/Part 1 · Query basics

Module 01

Reading data: SELECT

SELECT is the most important command in SQL. In this module you'll learn to read the products table from every angle: the columns you need, calculations, sorting, and limiting the number of rows.

0 / 8 lessonsStart module

Lessons8 lessons

  1. 01

    Now

    SELECT and FROM: getting data out

    The founder wants to do a stock-take — to see all the products at once. The quickest way is to pull the whole table with a single query. That's where we'll begin the module on reading data.

    Start
  2. 02Selecting only the columns you need
  3. 03Column aliases (AS)
  4. 04Expressions and calculations in SELECT
  5. 05DISTINCT: removing duplicates
  6. 06ORDER BY: sorting the result
  7. 07LIMIT and OFFSET: limiting the count
  8. 08Comments and formatting SQL