https://codapi.org/sql/

[codapi] codapi

[codapi] SQL Polyglot

Run a query and get results from:
[*] postgres:15.4 [*] mysql:8.1 [*] sqlite:3.44 [ ] mssql:2022 [ ]
 mariadb:11.2 [ ] clickhouse:23.10 [ ] duckdb:0.9


Write a query below or pick one:


    columns
    join using
    exists
    group by
    rollup
    window
    percentile
    fetch
    upsert
    except
    json
    recursive cte
    information schema
    arrays
    strings

select
  dense_rank() over w as erank,
  first_name, dep.name as dep_name,
  salary
from employee as emp
  join department as dep on emp.dep_id = dep.dep_id
window w as (order by salary desc)
order by erank, emp_id;

  employee                      department
+------------+-------------+  +------------+-------------+
|    name    |    type     |  |    name    |    type     |
+------------+-------------+  +------------+-------------+
| emp_id     | integer     |  | dep_id     | varchar(10) |
| first_name | varchar(50) |  | name       | varchar(50) |
| last_name  | varchar(50) |  | manager_id | integer     |
| birth_dt   | date        |  +------------+-------------+
| hire_dt    | date        |    salary
| dep_id     | varchar(10) |  +------------+-------------+
| city       | varchar(50) |  |   name     |  type       |
| salary     | integer     |  +------------+-------------+
|            |             |  | emp_id     | integer     |
|            |             |  | start_dt   | date        |
|            |             |  | end_dt     | date        |
|            |             |  | salary     | integer     |
+------------+-------------+  +------------+-------------+
You can add, remove or change database objects. This can
be tricky though, as the syntax should be cross-database
compatible to succeed.

SQL Polyglot is a quick way to see if a particular SQL feature is
supported in different database systems. Write a query and see it run
anywhere from PostgreSQL to DuckDB without leaving your browser.

Powered by codapi -- an open-source tool for embedding interactive
code examples into product docs, online courses and blogs. Give it a
try!

  * hey@codapi.org