SQL Example with SQL Editor

With our online SQL editor, you can edit the SQL statements, and click on a button to view the result.

Example

To select all columns from a table (Customers) for rows where the Last_Name column has Smith for its value, you would send this SELECT statement to the server back end:

SELECT * FROM Customers WHERE Last_Name='Smith';

The server back end would reply with a result set similar to this:

+---------+-----------+------------+
| Cust_No | Last_Name | First_Name |
+---------+-----------+------------+
| 1001 | Smith | John |
| 2039 | Smith | David |
| 2098 | Smith | Matthew |
+---------+-----------+------------+

3 rows in set (0.05 sec)