How to Write a Case Statement in Snowflake

Write a Case Statement in Snowflake

We use “CASE” statements while reaching for the "IF" statement in our "SELECT" clause.

Select
id1,
name1,
percentage,
Grade,
case
when percentage = 35 then ‘pass’
when percentage = 60 then ‘first class’
when percentage = 75 then ‘distinction’
when percentage >= 95 then ‘excellent’
else ’fail’
end as good_marks
From students

Conclusion

We will write a “Case” statement in the “Select” statement to work with the “if” statement. I hope this helps you use the “Case” statement in the “if” statement.

Snowflake Related Articles

▶  Snowflake vs Redshift
▶  Snowflake vs BigQuery
▶  Snowflake vs Databricks
▶  Snowflake vs Azure
▶  Snowflake vs Hadoop

▶  Snowflake Time Travel

If you have any queries, let us know by commenting below.