SQL Workspace - AI2sql

AI2sql LiveSQL

Navigator

Double-click tables/columns to insert into editor

Select a database to view tables

Worksheet

Free

Query result

Script output

DBMS output

Explain Plan

SQL history

Run a query to see results

No script output available

DBMS output is empty

Run EXPLAIN PLAN to see query execution details

Library

Community

Recently Viewed

Tutorial

SQL Macros - Creating parameterised views

This tutorial explains how to create a parameterized view using SQL Macros. The examples use the built-in sales history schema so there are no setup steps.

10 likes 620 executions

Script

How to Make Reusable SQL Pattern Matching

An overview of how to combine SQL pattern matching with SQL macros to create reusable code fragments.

1 likes 0 executions

Script

How to Find Gaps in Dates with SQL

Learn how to identify missing dates in your time series data using advanced SQL techniques.

5 likes 234 executions