Skip to content
Advertisement

Not less than operator

In snowflake how do I use a not less than operator?

If I want to return all rows that are not less than a value? Not sure if I want to use >= and tried !< but doesnt work

Thank

Advertisement

Answer

There no “not less than” operator, but it’s logically the same as “greater than or equal to”:

a >= b

or, if you want to express “not less than” as SQL:

not (a < b)
User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement