SQL Editor: Supported Features

Our SQL Editor is a browser-based database that can be used to enter and execute your own SQL statements. This is a great way to try our SQL tutorials and practice yourself.

Although this editor does not support all features in SQL, here is a list of what it does support:

Query Types

• SELECT Statement
• SELECT LIMIT Statement
• SELECT TOP Statement
• INSERT Statement
• UPDATE Statement
• DELETE Statement
• TRUNCATE TABLE Statement
• UNION Operator
• UNION ALL Operator
• INTERSECT Operator
• EXCEPT Query

Conditions and Operators

• AND Condition
• OR Condition
• LIKE Condition
• IN Condition
• NOT Condition
• IS NULL Condition
• IS NOT NULL Condition
• BETWEEN Condition
• EXISTS Condition
• Comparison operators such as =, <>, != >, >=, <, <=
  

Joins

• INNER and OUTER Joins

Aliasing

• ALIAS using AS keyword

Clauses

• DISTINCT Clause
• FROM Clause
• WHERE Clause
• ORDER BY Clause
• GROUP By Clause
• HAVING Clause

Functions

• Aggregate functions such as COUNT, SUM, MIN, MAX, AVG, FIRST, LAST, AGGR, ARRAY, REDUCE
• Functions such as ABS, IIF, IFNULL, INSTR, LOWER, UPPER, LCASE, UCASE, LEN, LENGTH, GREATEST, LEAST, CAST

Tables and Views

• CREATE TABLE Statement
• ALTER TABLE ADD COLUMN
• ALTER TABLE DROP COLUMN
• DROP TABLE [IF EXISTS]
• SHOW TABLES
• SHOW COLUMNS
• SHOW CREATE TABLE

Database

• CREATE DATABASE
• USE DATABASE
• DROP DATABASE