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