User Guide

Select Data from a Table

How to select data from a table using the SQL Query Tool.

To select specific columns from a table, type in your SQL statement and then click Run Query.

SELECT FirstName, LastName, Country FROM Customers

Run Select Statement

You can then view the data in the connection preview below.

Data Preview

Other SQL Statements

You can make use of any SQl statements not just CREATE and SELECT. For example, you can make use of UPDATE, DELETE and CASE Statements to edit and manipulate your data.

For more examples of SQL Statements and how these can be used please visit W3Schools.