Home
Compass SQL Reference
Query structure
Query structure
This section describes how a query is structured to retrieve data or information.
Side TOC
Side TOC
Compass SQL Reference
Query structure
SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY
UNION | UNION ALL
EXCEPT
INTERSECT
WITH
SELECT ALL
SELECT LIMIT number of rows
SELECT TOP number of rows
SELECT DISTINCT
SUBQUERIES
JOINS
Select individual properties from an object
Select individual properties using aliases from an object
Incorporate comments in a query
Select properties and include the Data Object load timestamp
Select records based on the last modified timestamp
Select all records
Select the Data Catalog Locale Selections
Select localized values for a property
Select localized values for a property and autofill unused property positions
Select localized values for a property that is not localized
Select a localized property without the locale function
Expressions and comparison functions
Logical and comparison operators
String functions
Mathematical operators
Mathematical functions
Aggregation functions
Datetime functions
Conversion functions
Analytic functions
Views