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 <code>WHERE</code> condition to filter rows.

Parameters

Optional field

Use in conjunction with the <code>WHERE</code> condition to prevent SQL injection attacks. After declaring the named bind variables in your <code>WHERE</code> input, assign values to these variables using this input field.

Order by

Optional field

Order of rows to return, such as <code>updated_at DESC</code>.

Limit

Optional field

The maximum number of rows to return. The default is <strong>100</strong>, and the highest possible number of rows is <strong>50000</strong> rows.

Offset

Optional field

The option to fetch only a page of results from the entire results set. <br/ ><br/ >For example, to skip the first 100 rows of the selected results set, input 100 to this field. <br/ ><br/ >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 <strong>Yes</strong> 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