Snowflake Articles
- Snowflake Interview Questions and Answers
- Snowflake Tutorial
- Snowflake Architecture
- What is Snowflake Data Warehouse
- Star schema and Snowflake schema in QlikView
- Snowflake vs Redshift - Which is the Best Data Warehousing Tool
- Snowflake vs BigQuery
- Snowflake Time Travel - A Detailed Guide
- What is a Snowflake Table & Types of Tables
- Snowflake vs Databricks
- Snowflake vs Azure
- Snowflake Vs Hadoop: What's the Difference?
- How to Insert Data in Snowflake
- Snowflake Connectors
- Snowflake Documentation - A Complete Guide
- How to Update Data in Snowflake?
- How to Delete Data in Snowflake
- How to Add a Default Value to a Column in Snowflake
- How to Add a Column in Snowflake
- How to Add a NOT NULL Constraint in Snowflake
- How to Alter a Sequence in Snowflake
- How to Create a Table in Snowflake
- How to Create a View in Snowflake
- How to create an Index in Snowflake
- How to Drop a Column in Snowflake
- How to Drop a Table in Snowflake
- How to Drop a View in Snowflake?
- How to Drop the Index in Snowflake
- How to Duplicate a Table in Snowflake
- How to Remove a NOT NULL Constraint in Snowflake
- How to Remove a Default Value to a Column in Snowflake
- How to Rename a Table in Snowflake
- How to Rename a Column in Snowflake
- How to write a Common Table Expression(CTE) in Snowflake
- How to Write a Case Statement in Snowflake
- How to Use Coalesce in Snowflake
- How to Query a JSON Object in Snowflake
- How to Truncate a Table in Snowflake
- How to Group by Time in Snowflake
- How to Import a CSV in Snowflake
- How to Query Date and Time in Snowflake
- How to Convert UTC to Local Time Zone in Snowflake
- How to Avoid Gaps in Data in Snowflake
- How do we Calculate the Running Total or Cumulative Sum in Snowflake
- How to Round Timestamps in Snowflake
- How to Calculate Percentiles in Snowflake
- How to Compare Two Values When One Value is Null in Snowflake
- How to do Type Casting in Snowflake
- How to Get First Row Per Group in Snowflake
- Snowflake Cloning - Zero Copy Clone
Snowflake - How to Have Multiple Counts
In Snowflake, for doing multiple counts in a single query, we have to combine “sum()” with “CASE Statement:”
select
count(1),
sum(case when name = ‘Table1’ then one else 0 end),
sum(case when category = 4, then one else 0 end),
from products1
Conclusion:
By merging the “CASE” statement and “sum()” function, we can get multiple counts in one query. I hope this is adequate for fetching multiple counts in Snowflake.
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.
On-Job Support Service
Online Work Support for your on-job roles.
Our work-support plans provide precise options as per your project tasks. Whether you are a newbie or an experienced professional seeking assistance in completing project tasks, we are here with the following plans to meet your custom needs:
- Pay Per Hour
- Pay Per Week
- Monthly
Learn MoreContact us
Course Schedule
| Name | Dates | |
|---|---|---|
| Snowflake Training | Apr 29 to May 14 | View Details |
| Snowflake Training | May 03 to May 18 | View Details |
| Snowflake Training | May 06 to May 21 | View Details |
| Snowflake Training | May 10 to May 25 | View Details |
Last updated: 04 Apr 2023
About Author
