SQL Aggregate Functions (COUNT, MAX, GROUP BY)
Tutorials that teach this
- Tutorial Access methods
- Tutorial Create Stored Procedures
- Tutorial Push Down a Spatial Workload to SAP HANA Database in SAP HANA Cloud
- Tutorial Create Stored Procedures
- Tutorial Connect to Data Lake Relational Engine Using the Go Driver
- Tutorial Query with the SQL Console in SAP HANA Database Explorer
- Tutorial Intermediate Table Variables
- Tutorial Connect Using the SAP HANA .NET Interface
- Tutorial Connect Using the SAP HANA Go Interface
- Tutorial Query the Database Using SQL Statements
Prerequisites
Concepts that build on this
- Concept SQL Date Functions (ADD_YEARS, CURRENT_DATE) for Filtering
- Concept Creating SQLScript Stored Procedures in SAP HANA
- Concept SQL INNER JOIN for Combining Tables
- Concept CREATE TABLE AS SELECT (CTAS) in SQL
- Concept Parallel Processing with Table Variables in SAP HANA SQLScript
- Concept Table User Defined Functions in SAP HANA
- Concept Creating SQL Views in SAP HANA
- Concept Data Lake Monitoring Views (iqmonViews)
- Concept SQL UNION ALL for Combining Table Results
- Concept Querying Points of Interest in SAP HANA Spatial
- Concept CCL Window Support in SAP HANA Streaming Analytics
- Concept Creating Functions in Visual Cloud Functions
- Concept DENSE_RANK Window Function for Row Ranking
- Concept SQL Nested Subqueries (WHERE IN SELECT)
- Concept Refreshing and Querying SAP HANA Anonymized Views
- Concept Creating a Streaming Project in SAP HANA Smart Data Streaming
- Concept Defining Column Tables with SQL in SAP HANA