Skip to content
ParticleDB
Release candidateParticleDB 1.1.19-rc.17 is not yet GA or ready for production data.Release status →

SELECT

Read, filter, sort and limit records.

CREATE TABLE docs_select (id BIGINT PRIMARY KEY, title TEXT, status TEXT);
INSERT INTO docs_select VALUES (1, 'Review', 'pending'), (2, 'Reply', 'completed');
SELECT id, title FROM docs_select
WHERE status = 'pending'
ORDER BY id LIMIT 10;

The query returns record 1. Use explicit ordering when the application needs a stable order. LIMIT without ORDER BY does not choose a predictable subset. Bound parameters belong in the client API.

SQL reference · Application guide · Troubleshooting