Select All Rows

Return every row from a table with an explicit sort order for deterministic output.

5/5 supported engines validation-green 1 example 2 scenarios

Docker-validated Not currently validation-green

Example 1

List all rows in a table

This example keeps the dataset tiny and adds ORDER BY id so the output is deterministic across engines.

Source table data Rows loaded before the example query runs.

Setup

CREATE TABLE people (id INT, name VARCHAR(50));

INSERT INTO
  people (id, name)
VALUES
  (1, 'Ada'),
  (2, 'Linus');

Validated query Shared across supported engines.

SQL

SELECT
  id,
  name
FROM
  people
ORDER BY
  id;

Expected result Returned rows for the shared example.

id	name
1	Ada
2	Linus

Validated on MySQL, MariaDB, SQL Server, and PostgreSQL with identical result shape.

Useful when

Explanation

Use SELECT with ORDER BY when you want a complete, stable result set for teaching or debugging examples.