SELECT
Read, filter, sort and limit records.
Example
Section titled “Example”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_selectWHERE status = 'pending'ORDER BY id LIMIT 10;Behavior
Section titled “Behavior”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.
Related
Section titled “Related”This site uses Google Analytics cookies to count visits. Privacy · License