EXISTS operator #
EXISTS (expr)
EXISTS operator returns true if the expr subquery result has rows.
select exists(select * from test);
[true]
select exists(select * from test limit 0);
[false]
EXISTS
EXISTS (expr)
EXISTS operator returns true if the expr subquery result has rows.
select exists(select * from test);
[true]
select exists(select * from test limit 0);
[false]