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

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.