Using Advanced SQL Conditions in SBM Reports

Note: Advanced SQL conditions are available only for on-premise customers.

SQL (Structured Query Language), is an ANSI-standard language for selecting records from a database.

A typical SQL selection statement looks something like this:

SELECT database_columns FROM database_table WHERE conditional_expression

Advanced SQL conditions provide you with two ways to implement or control your own SQL:

SQL Conditions Limitations

SBM Advanced SQL conditions does not support the use of the ORDER BY subquery. ORDER BY with OVER() function may be a valid use case for your database; however, SBM does not currently support that condition.

Related Topics

About Pass-Through SQL

About SBM–Processed SQL

Common SQL Operators