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', '[email protected]'),
  ('Bob', '[email protected]'),
  ('Charlie', '[email protected]');

Query 

SELECT * FROM users;

Interactive SQL execution coming soon