Re: How to select based on the condition of a column exists

2022-08-26 Thread David G. Johnston
On Fri, Aug 26, 2022 at 7:01 AM Shaozhong SHI wrote: > The following does not work. > select count(test) from table where exists (select test from table) > > > How to select based on the condition of a column exists? It column test > is not exists, a message need to be retu

How to select based on the condition of a column exists

2022-08-26 Thread Shaozhong SHI
The following does not work. select count(test) from table where exists (select test from table) How to select based on the condition of a column exists? It column test is not exists, a message need to be returned. Regards, David