LabKey SQL Examples
2024-04-25
The examples in this section illustrate some features of LabKey SQL that may be useful as you develop your own queries:
JOIN Queries
Calculated Columns
Pivot Queries
Queries Across Folders
Parameterized SQL Queries
Override Column Metadata with SQL Annotations
More examples
:
Query Columns with Duplicate Names
"Datasets" Special Column in Studies
Use "GROUP BY" for Calculations
Join a Calculated Column to Another Query
Calculate a Column Using Other Calculated Columns
Filter Calculated Column to Make Outliers Stand Out
Use "SIMILAR_TO"
Match Unknown Number of Spaces
Round a Number and Cast to Text
Efficient Use of "GROUP BY"
"COALESCE" Same-named Columns
Related Topics:
Query Metadata