# SELECT

Read, filter, sort and limit records.

Source: https://particledb.ai/sql/select/

Read, filter, sort and limit records.

## Example

```sql
CREATE TABLE docs_select (id BIGINT PRIMARY KEY, title TEXT, status TEXT);
INSERT INTO docs_select VALUES (1, 'Review', 'pending'), (2, 'Reply', 'completed');
```

```sql
SELECT id, title FROM docs_select
WHERE status = 'pending'
ORDER BY id LIMIT 10;
```

## 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

[SQL reference](/sql/overview/) · [Application guide](/guides/relational-data/) · [Troubleshooting](/guides/troubleshooting/)
