Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier.

We need a few examples of SELECT query under different schemas, both to validate the design and flesh out edge cases, as well as to show people how to use the data type to model SELECT queries.

The following example searches the SQL DICTIONARY.CATALOG rows for the SASUSER library and PROFILE catalog to find all catalog types of QUERY (saved SQL Query window queries). The name and description ...