relation-expression::=SELECT-clauseFROM-clause[
WHERE-clause]
[GROUP-BY-clause[
HAVING-clause]][
UNION-clause]
Searches the data from one or more relations and filters the search results.
SELECT-clause
For details about specifying the SELECT clause, see 4.4.4 SELECT clause.
FROM-clause
For details about specifying the FROM clause, see 4.4.5 FROM clause.
WHERE-clause
For details about specifying the WHERE clause, see 4.4.6 WHERE clause.
GROUP-BY-clause
For details about specifying the GROUP BY clause, see 4.4.7 GROUP BY clause.
HAVING-clause
For details about specifying the HAVING clause, see 4.4.8 HAVING clause.
UNION-clause
For details about specifying the UNION clause, see 4.4.9 UNION clause.
Enter the details of the relation expression in an inquiry. Specify a search method and a filtering method after the SELECT clause and the FROM clause, respectively.
None.
Outputs the data in column a where the value of column b in relation s1 is less than 20. The underlined part indicates the relation expression.
REGISTER QUERY q1 SELECT s1.a FROM s1[ROWS 100] WHERE s1.b < 20;