Open topic with navigation

Conditions.bool-primary-exists

Returns True if the result set is not empty

Format

EXISTS ( query-expr )

Remarks

Used to test if a result set contains at least one row.

Example:

SELECT A.NAME FROM A WHERE NOT EXISTS ( SELECT * FROM B WHERE B.ID = A.ID )

Disclaimer

ClearSCADA 2017 R2

© 2018 AVEVA Group Plc.  All Rights Reserved.

The Schneider Electric industrial software business and AVEVA have merged to trade as AVEVA Group plc, a UK listed company. The Schneider Electric and Life is On trademarks are owned by Schneider Electric and are being licensed to AVEVA by Schneider Electric.