add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE users (first_name TEXT, surname TEXT, age INTEGER, salary INTEGER);

✓

INSERT INTO users VALUES ('Rolf', 'Smith', 35, 55000);

✓

INSERT INTO users VALUES ('Bob', 'Smith', 37, 45000);

✓

INSERT INTO users VALUES ('Anne', 'Pun', 31, 87000);

✓

INSERT INTO users VALUES ('Charlie', 'Robert', 70, 99000);

✓

SELECT * FROM users WHERE first_name = 'Rolf';
first_name surname age salary
Rolf Smith 35 55000
SELECT * FROM users WHERE age > 33;
first_name surname age salary
Rolf Smith 35 55000
Bob Smith 37 45000
Charlie Robert 70 99000
SELECT * FROM users WHERE salary > 50000;
first_name surname age salary
Rolf Smith 35 55000
Anne Pun 31 87000
Charlie Robert 70 99000
SELECT * FROM users WHERE salary > 50000 AND age < 35;
first_name surname age salary
Anne Pun 31 87000
SELECT first_name, surname, age, salary
FROM users
WHERE (age <= 18 OR age >= 65) AND salary > 0;
first_name surname age salary
Charlie Robert 70 99000