SQLize
Online
/
PHPize Online
/
SQLtest Online
A
A
A
Share
Donate
Blog
Popular
Donate
A
A
A
Share
Blog
Popular
SQLize.online is a free online SQL environment for quickly running, experimenting with and sharing code.
You can run your SQL code on top of the most popular RDBMS including MySQL, MariaDB, SQLite, PostgreSQL, Oracle and Microsoft SQL Server.
SQL code:
Upload
Copy
Format
Clear
create schema seminar_2; CREATE TABLE seminar_2.salary ( employee_nm TEXT, department_nm TEXT, salary NUMERIC ); INSERT INTO seminar_2.salary VALUES('Ken Sánchez', 'HR', 78); INSERT INTO seminar_2.salary VALUES('TerriLee Duffy', 'HR', 95); INSERT INTO seminar_2.salary VALUES('Roberto Tamburello', 'HR', 382); INSERT INTO seminar_2.salary VALUES('Rob Walters', 'HR', 16); INSERT INTO seminar_2.salary VALUES('Gail Erickson', 'HR', 1079); INSERT INTO seminar_2.salary VALUES('Jossef Gibson', 'HR', 102); INSERT INTO seminar_2.salary VALUES('Dylan Miller', 'HR', 486); INSERT INTO seminar_2.salary VALUES('Diane Margheim', 'HR', 1953); INSERT INTO seminar_2.salary VALUES('Gigi Matthew', 'SALE', 49); INSERT INTO seminar_2.salary VALUES('Michael Raheem', 'SALE', 71); INSERT INTO seminar_2.salary VALUES('Ovidiu Cracium', 'SALE', 94); INSERT INTO seminar_2.salary VALUES('Thierry Hers', 'SALE', 61); INSERT INTO seminar_2.salary VALUES('Janice Galvin', 'SALE', 972); INSERT INTO seminar_2.salary VALUES('Michael Sullivan', 'SALE', 849); INSERT INTO seminar_2.salary VALUES('Sharon Salavaria', 'SALE', 715); INSERT INTO seminar_2.salary VALUES('David Michael', 'SALE', 94); INSERT INTO seminar_2.salary VALUES('Kevin Brown', 'R&D', 891); INSERT INTO seminar_2.salary VALUES('John Wood', 'R&D', 1486); INSERT INTO seminar_2.salary VALUES('Mary Dempsey', 'R&D', 176); INSERT INTO seminar_2.salary VALUES('Wanida Benshoof', 'R&D', 49); INSERT INTO seminar_2.salary VALUES('Terry Eminhizer', 'R&D', 381); INSERT INTO seminar_2.salary VALUES('Sariya Harnpadoungsataya', 'R&D', 946); INSERT INTO seminar_2.salary VALUES('Mary Gibson', 'R&D', 486); INSERT INTO seminar_2.salary VALUES('Jill Williams', 'R&D', 19); INSERT INTO seminar_2.salary VALUES('James Hamilton', 'R&D', 46); INSERT INTO seminar_2.salary VALUES('Peter Krebs', 'R&D', 445); INSERT INTO seminar_2.salary VALUES('Jo Brown', 'R&D', 666) ; INSERT INTO seminar_2.salary VALUES('Guy Gilbert', 'MANAGEMENT', 482); INSERT INTO seminar_2.salary VALUES('Mark McArthur', 'MANAGEMENT', 12); INSERT INTO seminar_2.salary VALUES('Britta Simon', 'MANAGEMENT', 194); INSERT INTO seminar_2.salary VALUES('Margie Shoop', 'MANAGEMENT', 481); INSERT INTO seminar_2.salary VALUES('Rebecca Laszlo', 'MANAGEMENT', 16); INSERT INTO seminar_2.salary VALUES('Annik Stahl', 'MANAGEMENT', 134); INSERT INTO seminar_2.salary VALUES('Suchitra Mohan', 'R&D', 87); INSERT INTO seminar_2.salary VALUES('Brandon Heidepriem', 'R&D', 111) ; INSERT INTO seminar_2.salary VALUES('Jose Lugo', 'R&D', 185); INSERT INTO seminar_2.salary VALUES('Chris Okelberry', 'R&D', 94); INSERT INTO seminar_2.salary VALUES('Kim Abercrombie', 'R&D', 348); INSERT INTO seminar_2.salary VALUES('Ed Dudenhoefer', 'R&D', 68); INSERT INTO seminar_2.salary VALUES('JoLynn Dobney', 'R&D', 346); INSERT INTO seminar_2.salary VALUES('Bryan Baker', 'R&D', 185); INSERT INTO seminar_2.salary VALUES('James Kramer', 'SUPPORT', 965); INSERT INTO seminar_2.salary VALUES('Nancy Anderson', 'SUPPORT', 444); INSERT INTO seminar_2.salary VALUES('Simon Rapier', 'SUPPORT', 133); INSERT INTO seminar_2.salary VALUES('Thomas Michaels', 'SUPPORT', 200); INSERT INTO seminar_2.salary VALUES('Eugene Kogan', 'SUPPORT', 144); INSERT INTO seminar_2.salary VALUES('Andrew Hill', 'SUPPORT', 186); INSERT INTO seminar_2.salary VALUES('Ruth Ellerbrock', 'SUPPORT', 179); INSERT INTO seminar_2.salary VALUES('Barry Johnson', 'HEAD', 10000); INSERT INTO seminar_2.salary VALUES('Sidney Higa', 'HEAD', 1); INSERT INTO seminar_2.salary VALUES('Max Lanson', 'PR', 150); SELECT * FROM seminar_2.salary; create schema seminar_3; /*Exersise 2*/ CREATE TABLE seminar_3.department ( department_nm TEXT, location_txt TEXT ); /*Exersise 3*/ INSERT INTO seminar_3.department VALUES('HR', 'Moscow'); INSERT INTO seminar_3.department VALUES('LOGISTICS', 'Moscow'); INSERT INTO seminar_3.department VALUES('R&D', 'Saint Petersburg'); INSERT INTO seminar_3.department VALUES('MANAGEMENT', 'Novosibirsk'); INSERT INTO seminar_3.department VALUES('SUPPORT', 'Saint Petersburg'); INSERT INTO seminar_3.department VALUES('HEAD', 'Novosibirsk'); INSERT INTO seminar_3.department VALUES('PR', 'Moscow'); SELECT * FROM seminar_3.department; /*Exersise 5*/ SELECT employee_nm FROM seminar_2.salary as s JOIN seminar_3.department as d ON s.department_nm=d.department_nm WHERE d.location_txt='Moscow'; /*Exersise 5*/ SELECT employee_nm FROM seminar_2.salary JOIN seminar_3.department USING (department_nm) WHERE location_txt='Moscow'; /*Exersise 6*/ SELECT * FROM seminar_2.salary RIGHT OUTER JOIN seminar_3.department USING (department_nm);
SQL
Server:
MariaDB 11.4
MariaDB 11.5
MariaDB 10
MariaDB 10 Sakila (ReadOnly)
MySQL 5.7
MySQL 5.7 Sakila (ReadOnly)
MySQL 8.0
MySQL 8.0 Sakila (ReadOnly)
SQLite 3
PostgreSQL 10 Bookings (ReadOnly)
PostgreSQL 11
PostgreSQL 12
PostgreSQL 13
PostgreSQL 14
PostgreSQL 15
MS SQL Server 2017
MS SQL Server 2019
MS SQL Server 2022
MS SQL Server 2022 AdventureWorks (ReadOnly)
Firebird 4.0
Firebird 4.0 (Employee)
Oracle Database 19c (HR)
Oracle Database 21c
Oracle Database 23c Free
SOQOL
Version
ER Diagram
Preserve result
Stuck with a problem?
Got Error?
Ask ChatGPT!
Result:
Copy
Clear