select
Use select to retrieve full rows or specified columns from a table by applying a where clause to each row to determine whether to include the row or column in the selection.
Basic syntax
To select full rows from a table based on a where clause, use the following syntax:
(select table where)
To select specific columns from a table based on a where clause, use the following syntax:
(select table columns where)
Arguments
Use the following arguments to specify the table, columns, and where clause for selecting rows using the select Pact function.
| Argument | Type | Description |
|---|---|---|
table | table: <{row}> | Specifies the table from which to select rows matching the where clause. |
columns | [string] | Specifies the list of columns to select from the table matching the where clause (optional). |
where | row:object:<{row}> | Specifies the where clause to apply to each row to determine inclusion. |
Return value
The select function returns a list of objects representing the selected rows from the table that satisfy the where condition.
Examples
The following example demonstrates how to use the select function to select the columns 'firstName and 'lastName from the people table where the name is equal to "Fatima":
(select people ['firstName 'lastName] (where 'name (= "Fatima")))
The following example demonstrates how to select all columns from the people table where the age is less than 30:
(select people (where 'age (> 30)))