• Create filtered grid views of data.
• Join data from different tables.
• Group data and compute aggregates for each group.
• Add a calculated column to a query.
• Format how data is displayed using query metadata.
• Create staging tables for building reports.

• An intuitive table-joining syntax called lookups. Lookups use a convenient syntax of the form "Table.ForeignKey.FieldFromForeignTable" to achieve what would normally require a JOIN in SQL. For details see LabKey SQL Reference.
• Parameterized SQL statements. Pass parameters to a SQL query via a JavaScript API.

Topics

• LabKey SQL Tutorial - Create a SQL Query.
• SQL Query Browser - A dashboard for all things SQL-related, such as database schemas, tables, columns, and queries.
• LabKey SQL Reference - SQL syntax and reference.
• Create a SQL Query - How to create a database query and view the results.
• Edit SQL Query Source - How to use the SQL source editor.
• Query Metadata - Control how your query is displayed using metadata.
• Query Web Part: Display a Query - How to show query results in your project.
• Add a Calculated Column to a Query - Set a calculated column query.
• Create a Pivot Query - Reshape a table and aggregate data.
• Parameterized SQL Queries - Work with parameterized SQL.
• SQL Examples: JOIN, Calculated Columns, GROUP BY - Sample SQL queries.
• Cross-Folder Queries - Commonly performed tasks, troubleshooting.

Related Topics

• External Schemas and Data Sources - Connect to external database resources.
• Lookup Columns - Use LabKey's graphical user interface to setup lookup columns joining tables.
• Join Columns from Multiple Tables - Use LabKey's graphical user interface to create joined grid views.
• Linked Schemas and Tables - Control data visibility by linking schemas from different folders.
• Modules: SQL Scripts - Manage SQL scripts inside of custom modules.
• XML Schema Reference