Structured Query Language (SQL) is a database query and programming language used to access data, as well as query, update, and manage relational database systems. In SuperMap iDesktopX, constructing SQL Query allows extraction, updating, deletion, and management of geographic data from spatial databases.

This chapter provides detailed explanations of the following content:

• Build SQL Query: Explains how to quickly query geographic data information in spatial data using the SQL Query function.
• Build SQL Expression Query: Describes how to perform geographic data queries using the SQL Expression Query function.
• Common Expressions for Building SQL Queries: Introduces how to construct commonly used query condition expressions.
• Function Specifications for Building SQL Queries: Explains frequently used functions for constructing query statements and their usage conditions.
• Attribute Query Examples: Provides detailed guidance on quickly querying geographic spatial data using sample data.
• Group Statistics Examples: Demonstrates how to perform group statistics on single or multiple fields using sample data.