Home
SQL Data Sets - Online help Prev Page Prev Page
Introduction
About SQL Data Sets
Version history
Supported database engines
Contact us
Getting started
Creating a result set package
Opening and using a SQL Data Sets package
Using SQL Data Sets
Connecting to a database server
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
The SQL workspace
SQL editor
Data sets
HTML export
Adding and viewing notes
Viewing images
Creating a package
Exporting to a SQLite database
Options
Using SQL Data Sets Viewer
Opening a package
Local queries
Local SQL commands and functions

Local queries

You can run SQL queries against the data sets contained in a package. You do not need to be connected to a database server in order to run local queries, nor install any database engines on your workstation. The list of supported SQL commands and functions is available here.

In the example below, the package contains 2 data sets.

localsql01  

We can run the following query against the first data set to summarise total orders to date grouped by territory. The results of the local query is then displayed, and marked as local SQL
to indicate that it is a data set generated from a local SQL query.

localsql02  


When you run a local query, the first data set is referred to as ds1, the second data set as ds2 and so on.

You can also join multiple data sets using standard SQL constructs like INNER JOIN and OUTER JOIN. The next query uses data from the 2 data sets, to return the name of all products sold in Australia, together with each product's thumbnail photo.

localsql03