All problemsSelect All Employees

31. Select All Employees

EasyDatabases~3 min

Write a query that returns every column and every row from the employees table.

This is the simplest query there is, and it is the one you will type most often while exploring an unfamiliar database.

Examples

Example 1

Input:: employees
Output:: all 8 rows, with the columns id, name, department_id, salary, hired_on

Constraints

Return every column.
Row order does not matter.
Column names are not checked — only the values and how many columns you return.

Database

Loading tables…

Show CREATE statements

CREATE TABLE departments (
  id   INTEGER PRIMARY KEY,
  name TEXT NOT NULL
);

CREATE TABLE employees (
  id            INTEGER PRIMARY KEY,
  name          TEXT NOT NULL,
  department_id INTEGER,
  salary        INTEGER NOT NULL,
  hired_on      TEXT NOT NULL
);

INSERT INTO departments (id, name) VALUES
  (1, 'Engineering'),
  (2, 'Sales'),
  (3, 'Support');

INSERT INTO employees (id, name, department_id, salary, hired_on) VALUES
  (1, 'Ana Reyes',    1, 72000, '2021-03-15'),
  (2, 'Ben Cruz',     1, 68000, '2020-07-01'),
  (3, 'Carla Diaz',   2, 54000, '2022-01-20'),
  (4, 'Dino Lim',     2, 51000, '2019-11-05'),
  (5, 'Elena Santos', 3, 47000, '2023-06-12'),
  (6, 'Frank Uy',     1, 95000, '2018-02-28'),
  (7, 'Grace Tan',    3, 49000, '2022-09-30'),
  (8, 'Hector Ramos', NULL, 60000, '2024-01-08');

SQLite

Loading editor…

⌘/Ctrl + ↵ to run