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 table science_class (Enrollment_no INT, Name VARCHAR, Science_Marks DECIMAL); insert into science_class values (1, 'Popeye', -33.347); insert into science_class values (2, 'Olive', 54.589); insert into science_class values (3, 'Brutus', 98.452); insert into science_class values (4, 'Robb', 75.856); insert into science_class values (5, 'Olive', 98.452); insert into science_class values (6, 'Brutus', 127.541); select abs(science_marks) from science_class where name = 'Popeye'; create table science_id (id INT); insert into science_id values (1); select * from science_class; select sum(science_marks) as total_marks, count(enrollment_no) as total_enrollment from science_class where science_class.enrollment_no = (select id from science_id); select name from science_class where science_marks > 60; select name, sum(science_marks) from science_class group by name having sum(science_marks) > 100; select * from science_class where science_marks between 35 and 60; select * from science_class where science_marks not between 35 and 60; select count(*) from science_class where science_marks not between 35 and 60; UPDATE science_class SET science_marks = 45 WHERE name = 'Popeye'; alter table science_class rename column name to student_name; select * from science_class order by enrollment_no desc; select * from science_class order by enrollment_no asc limit 3; select enrollment_no, student_name from science_class; select * from science_class where student_name in ('Popeye', 'Olive'); select distinct student_name from science_class where student_name in ('Popeye', 'Olive'); select * from science_class where student_name like '_l%'; select * from science_class where student_name like '_^l%'; select * from science_class where student_name like 'B%'; select sum(science_marks) from science_class; select round(sum(science_marks),0) from science_class; select avg(science_marks) from science_class where student_name = 'Olive'; select min(science_marks) as min_age, max(science_marks) as max_age from science_class where student_name = 'Olive'; select distinct student_name from science_class where mod (enrollment_no, 2) = 0 order by student_name desc; select (count(science_marks) - count(distinct science_marks)) as science_count from science_class; select min (length(student_name)) from science_class; select distinct lower(substr(student_name, 1, 1)) as sub_name from science_class; select distinct student_name from science_class where lower(substr(student_name, 1, 1)) in ('p', 'o','e', 'y'); SELECT sqrt(power(3,2));
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