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.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Condition
Condition with Subquery
ALL, ANY, and SOME Subqueries

ALL, ANY, and SOME Subqueries

Use the ALL, ANY, and SOME keywords to specify what makes the condition TRUE or FALSE. A search condition that is TRUE when the ANY keyword is used might not be TRUE when the ALL keyword is used, and vice versa.

ALL, ANY, SOME Subquery

Notes:

¹ See Expression
² See Relational Operator


Element	Description	Restrictions	Syntax
subquery	Embedded query	Cannot contain the FIRST or the ORDER BY clause	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.