SQL Guide

MetaKraftwerk supports standard SQL, including a subset of ANSI SQL:1999 and the analytical extensions of SQL:2003.

Basics

Learn how to start with SQL in MetaKraftwerk, how to create a sql sheet and how to execute sql statements.

Using Joins

A join combines rows from two tables to create a new combined row that can be used in the query. Learn join concepts, types of joins, and how to work with joins.

Using Subqueries

A subquery is a query within another query. Learn more about subqueries and how to use them.

Querying hierarchical data

Relational databases often store hierarchical data in different tables. Learn about querying hierarchical data using joins, common table expressions (CTEs), and CONNECT BY.

Working with CTEs (Common Table Expressions)

A CTE (common table expression) is a named subquery defined in a WITH clause that returns a table. Learn how to write and work with CTE expressions.

Using Window Functions

Window functions work with "windows", which are groups of rows that are related in some way. Learn more about windows, window functions, and using window functions to explore data.