# IBM Db2 - Select rows
Select specific data using common filter operators, such as WHERE
, LIMIT
and OFFSET
. You can also specify which columns to return using the Output columns
field.
Returns rows that match the WHERE
condition from the selected table.
# Select rows
# Input fields
- Table
- Required field
- Select the target table or view. You can also toggle the input to text mode, and enter the name of the table or view.
- WHERE condition
- Optional field
- The
WHERE
condition to filter rows.
- Parameters
- Optional field
- Use in conjunction with the
WHERE
condition to prevent SQL injection attacks. After declaring the named bind variables in yourWHERE
input, assign values to these variables using this input field.
- Order by
- Optional field
- Order of rows to return, such as
updated_at DESC
.
- Limit
- Optional field
- The maximum number of rows to return. The default is 100, and the highest possible number of rows is 50000 rows.
- Offset
- Optional field
- The option to fetch only a page of results from the entire results set.
For example, to skip the first 100 rows of the selected results set, input 100 to this field.
The default is 0.
- Output columns
- Optional field
- Define specific columns to retrieve from the target table. By default, retrieves all columns.
- Output CSV?
- Optional field
- Select Yes to output a CSV string of the selected data.
# Output fields
- rows
- Array of JSON objects, where each object represents a retrieved row.
- rows_count
- Number of reetrieved rows
Last updated: 2/20/2024, 5:01:26 PM