# SharpenDB SELECT (/docs/workflows/reference/category/data/sharpenDbSelect)

> For the complete documentation index, see [llms.txt](https://docs.tandemcx.ai/llms.txt). Any page on this site can be fetched as Markdown by appending `.md` to its URL.

Run a SELECT query on a table in SharpenDB.

Reads rows from a SharpenDB table. Choose the table and the fields to return (leave fields blank for all), narrow results with `Where` conditions, and optionally sort. Capture columns from the result into variables by JSONPath so later nodes can use them with `$(name)`. The flow takes `default` when the query succeeds. A query SharpenDB does not answer within 20 seconds takes `timeout`, or `fallback` when `timeout` is not wired. The node's Timeout field is not applied: it does not change that 20-second limit.

**Category:** Data  
**Provider:** Sharpen  
**Requires integration:** sharpen  
**Latest version:** 1.0.0

## Fields

| Field | Type | Required | Description |
| --- | --- | --- | --- |
| Table (`table`) | dynamicDropdown | Yes | The table to query from. |
| Fields (`fields`) | dynamicDropdown | No | The fields from the table to include in the query. Leave blank to query all. |
| Where (`where`) | dynamic array of fields with options | Yes | WHERE conditions to filter query results. Each condition compares a table field using an operator against a value. |
| Where Operator (`whereConditionOperator`) | string | No | What operator (AND/OR) to use for the where condition. |
| Sort By (`sortBy`) | dynamicDropdown | No | Which field to sort the query by. Leave blank for default sorting. |
| Distinct (`distinct`) | boolean | No | When true, removes duplicate rows from the query results. |
| Limit (`limit`) | number | No | Maximum number of rows to return (1-25). |
| Offset (`offset`) | number | No | Number of rows to skip before returning results. Use with limit for pagination. |
| Unpaginated Count (`count`) | boolean | No | When true, includes the total count of matching rows before pagination is applied. |
| Variables (`variables`) | array of objects | No | Save variables from the data returned. |
| Timeout (`timeout`) | number | No | Not applied yet: SharpenDB queries always wait up to 20 seconds, whatever this is set to. |

## Exits

- `default` (required)
- `timeout` (required)
- `invalidInput` (system)
- `fallback` (system)

System exits (auto-injected, hidden when unwired): `invalidInput`, `fallback`.