Select All

This example demonstrates the basic SELECT statement to retrieve all rows from a table. The `SELECT *` syntax returns all columns for every row in the table.

Setup 

CREATE TABLE users (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  email TEXT UNIQUE
);

INSERT INTO users (name, email) VALUES
  ('Alice', 'alice@example.com'),
  ('Bob', 'bob@example.com'),
  ('Charlie', 'charlie@example.com');

Query 

SELECT * FROM users;

Interactive SQL execution coming soon