SQL Querying Fundamentals (SELECT, WHERE, GROUP BY, ORDER BY)
The concept name was not provided, so a precise definition cannot be generated. Please supply a valid concept name along with supporting source snippets so that an accurate, grounded definition can be written.
Tutorials that teach this
- Tutorial Create a User, Tables and Import Data Using SAP HANA HDBSQL
- Tutorial Browse Schema with the Database Browser in SAP HANA Database Explorer
- Tutorial Create Users and Manage Roles and Privileges
- Tutorial Execute SQL Commands and Create Custom Notifications with SAP Automation Pilot and SAP Alert Notification Service
- Tutorial Access methods
- Tutorial View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
- Tutorial Query with the SQL Console in SAP HANA Database Explorer
- Tutorial View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
- Tutorial Display Database Content and Run SQL Queries
- Tutorial Query the Database Using SQL Statements
Prerequisites
- Concept SAP HANA In-Memory Platform Fundamentals
- Concept SAP HANA Fuzzy Search on Text Data The concept name was not provided, so a specific definition cannot be generated. Please supply a valid concept name to receive an accurate, source-grounded definition.
- Concept Well-Known Text (WKT) and ST_GeomFromText in SAP HANA A definition cannot be written because no concept was provided and the supplied sources do not identify a specific SAP developer concept to define. Please provide a valid concept name so that a grounded definition can be produced.
- Concept SAP HANA Cloud fundamentals The concept name was not provided, and the available source snippets do not contain enough detail to define a specific SAP developer concept with accuracy. The sources reference topics such as [setting up database artifacts](https://help.sap.com/docs/btp/sap-business-technology-platform/3cd69547217949e098fb4f2a88aa6d33?locale=en-US&state=PRODUCTION&version=Cloud) in SAP HANA, connecting via JDBC, spatial data visualization, and migrating to SAP HANA Cloud, but no specific concept name or substantive explanatory content was supplied to ground a precise definition.
- Concept SAP HANA Cloud Connection Management The concept provided is **undefined**, and the supplied sources do not contain enough grounded information to produce a reliable, accurate definition for a specific SAP developer concept. To generate a valid definition, please provide a clearly named concept (for example, "SAP HANA Database Explorer" or "Smart Data Integration") along with relevant source snippets that describe it.
- Concept SAP HANA Database Explorer The concept to be defined is missing or marked as "undefined," and the provided sources do not converge on a single, clearly identifiable SAP developer concept. Without a valid concept name, a grounded and accurate definition cannot be produced.
- Concept Extended Storage Dbspace Creation and Removal The concept name is missing or undefined, and the provided sources discuss SAP HANA Dynamic Tiering topics such as extended storage, dbspace file management, and monitoring via SAP HANA Cockpit and SAP HANA Studio — but do not supply enough grounded detail to write a reliable definition for an unnamed concept. Please provide the concept name so an accurate, source-grounded definition can be written.
- Concept SAP HANA In-Memory Relational Database The concept name was not provided (marked as "undefined"), and the available source snippets do not contain sufficient detail to construct a grounded, accurate reference definition. Only one source ([S1]) references a relevant topic — setting up database artifacts using SAP HANA — but without a named concept to define, a precise and accurate definition cannot be written per the documentation guidelines.
Concepts that build on this
- Concept SAP HANA Dynamic Tiering Query Plan Analysis and Index Creation
- Concept SAP HANA Cloud Data Lake
- Concept SAP HANA Spatial Hexagonal Clustering
- Concept HDBTABLE Object Definition and Column Definitions
- Concept .NET Driver for SAP HANA Cloud Data Lake Relational Engine
- Concept SAP HANA Multi-Store Tables
- Concept SAP HANA Spatial Type Hierarchy and SQL/MM Standard
- Concept Auto Commit and Manual Transaction Control in SQL
- Concept Well-Known Text (WKT) and ST_GeomFromText in SAP HANA
- Concept Schema and Configuration Management
- Concept SQL Console in SAP HANA Cloud Central
- Concept GraphScript Procedures in SAP HANA
- Concept SQLScript Scalar User-Defined Functions (UDFs)
- Concept SPARQL Querying
- Concept Data Filtering and Sorting
- Concept Querying Points of Interest with SAP HANA Spatial
- Concept Import and Export Management
- Concept SAP HANA Cloud Instance Provisioning
- Concept HANA Table Partitioning and Indexing
- Concept Predictive Modeling and Model Training
- Concept OpenCypher Pattern Matching Queries
- Concept SAP HANA HDBSQL Command-Line Tool Basics
- Concept Foreign Key Constraints and Referential Integrity
- Concept SQL CREATE VIEW Statement
- Concept SAP HANA Security and User Management
- Concept SAP HANA Predictive Analysis Library (PAL)
- Concept Hibernate Query Language (HQL/JPQL) and Native SQL Queries
- Concept SQLScript Anonymous Blocks
- Concept SAP HANA Monitoring Views (M_ prefix)
- Concept SAP HANA Advanced Analytics
- Concept User Provisioning
- Concept SAP HANA Cloud Database Objects App
- Concept CDS Table Functions
- Concept dbisql Command-Line Tool for SAP HANA Cloud Data Lake
- Concept SQLScript Table User-Defined Functions
- Concept SQL Nested Queries and Subqueries
- Concept SAP HANA Calculation Views
- Concept Go database/sql Package for Relational Queries
- Concept SAP HANA Database Explorer
- Concept SAP HANA Graph Workspace Usage
- Concept GenAI Tools in the SQL Console (Natural Language to SQL, Explain, Optimize)
- Concept Remote Sources and Virtual Tables in SAP HANA Cloud
- Concept SQL JOIN Operations (INNER JOIN)
- Concept SAP HANA Spatial Column Types (ST_GEOMETRY, ST_POINT)
- Concept SQL Aggregate Functions (COUNT, MAX)
- Concept Java application development
- Concept SQL UNION ALL for Combining Result Sets
- Concept SAP HANA Dynamic Tiering (Extended Tables)
- Concept SAP HANA Database Explorer Data Import
- Concept SAP HANA Spatial Access Functions (ST_X, ST_Dimension)
- Concept SAP HANA Stored Procedure Creation and Execution
- Concept CREATE TABLE AS SELECT (CTAS) in SQL
- Concept SAP HANA Cloud Data Lake Monitoring Views
- Concept SAP HANA Anonymized Views
- Concept Selective Data Migration Between In-Memory and Extended Storage
- Concept SQL Console Statement Library
- Concept SAP HANA Python Database Client (hdbcli)
- Concept SAP HANA In-Database Machine Learning
- Concept SAP HANA Spatial LineString and CircularString Types
- Concept SQL Explain Plan for Query Execution Analysis
- Concept SAP HANA Spatial Transformation Methods (ST_Boundary, ST_Envelope, ST_ConvexHull, ST_Buffer)
- Concept SQL Console Background Statement Execution