CSE Roadmap

Core tier · about 3 hours · 5 parts

Part 1 of 5 · 1 min read

Why this page comes first

In this module you will

  • Write a SELECT with a WHERE condition using comparison and logical operators.
  • Sort results with ORDER BY, ascending or descending, on more than one column.
  • Page through a large result using LIMIT and OFFSET.
  • Read any basic SELECT statement and predict exactly what rows it returns, in what order.

Level 0 showed SELECT just enough to read earlier examples. This page goes properly deep on it. Nearly every later module needs confident filtering and sorting.