SQL Tryit Editor v1.6

SQL Statement:

​x
 
SELECT OrderID, Quantity,CASE WHEN Quantity > 30 THEN "The quantity is greater than 30"WHEN Quantity = 30 THEN "The quantity is 30"ELSE "The quantity is under 30"END AS QuantityTextFROM OrderDetails;​        

Edit the SQL Statement, and click "Run SQL" to see the result.

Result:

Click "Run SQL" to execute the SQL statement above.

W3Schools has created an SQL database in your browser.

The menu to the right displays the database, and will reflect any changes.

Feel free to experiment with any SQL statement.

You can restore the database at any time.

The Try-SQL Editor ? ×
at w3schools.com

This SQL-Statement is not supported in the WebSQL Database.

The example still works, because it uses a modified version of SQL.

Your browser does not support WebSQL.

Your are now using a light-version of the Try-SQL Editor, with a read-only Database.

If you switch to a browser with WebSQL support, you can try any SQL statement, and play with the Database as much as you like. The Database can also be restored at any time.

Our Try-SQL Editor uses WebSQL to demonstrate SQL.

A Database-object is created in your browser, for testing purposes.

You can try any SQL statement, and play with the Database as much as you like. The Database can be restored at any time, simply by clicking the "Restore Database" button.

W3C WebSQL

WebSQL stores a Database locally, on the user's computer. Each user gets their own Database object.

WebSQL Browser Support

WebSQL is supported in Chrome, Safari, and Opera.

If you use another browser you will still be able to use our Try SQL Editor, but a different version, using a server-based ASP application, with a read-only Access Database, where users are not allowed to make any changes to the data.

Your Database:

SQL Statement:

Result:

The Try-SQL Editor ? × at w3schools.com

W3C WebSQL

WebSQL Browser Support

The Try-SQL Editor ? ×
at w3schools.com