Questions tagged [loop]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
2 answers

Find all where none of the rows of B have is_true='Y'?

There are two tables C and B. They're connected by I need to find all the es where: None of the rows corresponding to cid has is_true='Y' I've tried various queries but can't wrap ...
barnyard9's user avatar
0 votes
0 answers

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 ...
user45867's user avatar
  • 1,651