Questions tagged [loop]
The loop tag has no usage guidance.
2
questions
0
votes
2
answers
51
views
Find all C.id where none of the rows of B have is_true='Y'?
There are two tables C and B.
They're connected by C.id=B.cid.
I need to find all the C.id es where:
None of the rows corresponding to cid has is_true='Y'
I've tried various queries but can't wrap ...
0
votes
0
answers
13
views
Snowflake For i in 1 to 10 - can't figure out variable scope
I can't figure out Snowflake variables. I have:
Declare
max_count integer default 100;
product varchar default null;
BEGIN
for i in 1 to max_count
do
let product = (select product from mytable where ...
- 1,651