SQL Clauses

DISTINCT – A SELECT clause that specifies to return only distinct values.
EXCEPT – Returns results that are in the first specified query, but not in the second specified query.
FETCH – Limits the number of rows returned be a query.
FROM – A SELECT clause that specifies one or more tables to query.
GROUP BY – A SELECT clause that groups the resulting rows of a query according to one or more columns.
HAVING – A SELECT clause that specifies one or more restrictive conditions on a group of data values.
INTERSECT – Returns results that are in both of the specified queries.
INTO – A SELECT clause that specifies the storing of selected values in host variables.
LIMIT – Limits the number of rows returned by a query.
ORDER BY – A SELECT clause that specifies the sorting of rows in a result set.
TOP – A SELECT clause that specifies how many rows to return.
UNION – Combines two or more SELECT statements.
VALUES – An INSERT/UPDATE clause that specifies data values for use in fields.
WHERE – A SELECT clause that specifies one or more restrictive conditions.
WHERE CURRENT OF – An UPDATE/DELETE clause that specifies the current row using a cursor.
WITH – A clause to specify Common Table Expressions which allow a subquery to be easily used within a main query.

SQL Predicate Conditions

SQL Commands

Purpose of this instance: Draft documentation

DocReleaseID: HealthConnect2025.1

Content loaded from:

/staging/learning/iris-doc/2025.1.x/doc/cache/en-us/src/

/staging/learning/iris-doc/2025.1.x/doc/ensemble/en-us/src/

/staging/learning/iris-doc/2025.1.x/doc/healthconnect/en-us/src/

/staging/learning/iris-doc/2025.1.x/doc/healthcommon/en-us/src/

/staging/learning/iris-doc/2025.1.x/doc/security/en-us/src/

Excluded items: AADAN, ABIT, ACLOUD, AFL_adonet, AFL_ecp, AFL_icm, AFL_jdbc, AFL_netxep, AFL_sharding, AFL_xep, APMML, APOWER, ARGATEWAY, AWEBSOCKETS, AWSGI, BJAVA, BJAVNAT, BJAVPER, BJAVXEP, BJSNAT, BNET, BNETNAT, BNETODBC, BNETXEP, BPYNAT, BSPK, BTPI, BXCI, GAUTOML, GCONV, GCSP, GICM, GIKNOW, GIML, GISQ, GISR, GSCF, GSQLSRCH, GTSQ, GUIMA, PAGE_activex, PAGE_administration, PAGE_apimgr, PAGE_appdev_ides, PAGE_bi, PAGE_cachedirect, PAGE_data_migration, PAGE_data_science, PAGE_deployment, PAGE_deployment_configuration, PAGE_deployment_containers, PAGE_deployment_icm, PAGE_deployment_iko, PAGE_deployment_install, PAGE_dotnet, PAGE_dotnet_native, PAGE_dsvr, PAGE_embedded_language_development, PAGE_epython, PAGE_external_language_development, PAGE_interop, PAGE_interop_lifecycle, PAGE_interop_vdoc, PAGE_interoperability, PAGE_java, PAGE_java_jdbc, PAGE_java_native, PAGE_machine_learning, PAGE_monitoring, PAGE_multimodel, PAGE_multimodel_multidimensional, PAGE_multimodel_object, PAGE_multivalue, PAGE_native, PAGE_nodejs_native, PAGE_objectscript, PAGE_objectscript_ides, PAGE_odbc, PAGE_platform_arch_design, PAGE_pygate, PAGE_python, PAGE_python_native, PAGE_reports, PAGE_scalability, PAGE_security_authentication, PAGE_security_authorization, PAGE_studio, PAGE_zen, PAGE_zenmojo, PAGE_zenreports