Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
SELECT statementUse the SELECT statement to retrieve values from a database or from an SPL or collection variable. A SELECT operation is called a query.
WHERE clause of SELECTThe WHERE clause can specify join conditions for HCL OneDB™-extension joins, post-join filters for ANSI-compliant joins, and for search criteria on data values.

WHERE clause of SELECT

The WHERE clause can specify join conditions for HCL OneDB™-extension joins, post-join filters for ANSI-compliant joins, and for search criteria on data values.

This syntax fragment is part of the SELECT statement.

WHERE Clause

Notes:

¹ See Condition
² See Specifying a Join in the WHERE Clause
³ See Function Expressions
⁴ See Collection Subquery
⁵ See Statement-Local Variable Expressions


Element	Description	Restrictions	Syntax
Logical_ Operator	Combines two conditions	Valid options are logical union (= OR or OR NOT) or logical intersection ( = AND or AND NOT)	Conditions with AND or OR
subquery	Embedded query	Cannot include the FIRST or ORDER BY keywords	SELECT statement