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

Geo SCADA Expert 2020

© 2020 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. Schneider Electric, Life is On Schneider Electric and EcoStruxure are trademarks and the property of Schneider Electric SE and are being licensed to AVEVA by Schneider Electric.