Help - SQL SELECT function

Help Center How To Use Our Products? SQL SELECT function

SELECT function


This functionality is only available in Spotzi Studio.

If you want to select particular columns of your dataset and view this selection on your MY DATA homepage use a SELECT query. When you open a dataset from your MY DATA page and open the SQL box on the right side, you will see the following code:

SELECT * FROM {name of dataset}

As you can see this is a SELECT query where all columns of a dataset are shown. The setup of this query looks like this:

  • The SELECT keyword is used to select data from the database;
  • The asterisk (*) is used to select all columns;
  • The FROM keyword indicates that the data is selected from a particular dataset;
  • After the FROM statement the name of the dataset that contains the data you are looking for is specified.

In the example below you can see a SELECT statement that selects all columns of the dataset usa_salesmanagers_2_digit_areas.

SELECT * FROM usa_salesmanagers_2_digit_areas


If you want to select only certain columns of a dataset you have to replace the asterisk (*) with the name of the columns. If you want to select more than one column use a comma to separate the columns. In the example below we want to show only the pc2 and salesmanager column of the usa_salesmanager_2_digit_areas dataset.

SELECT pc2, salesmanager FROM usa_salesmanagers_2_digit_areas


Related blog posts

Interested in our solutions? Please contact our sales team.

Whether you are new to data analytics or already an expert. We offer solutions for everyone. You don’t need to be a data expert to work with Spotzi Location. For more tailor made solutions we offer Spotzi Studio. With this plan you cannot only manage the data yourself but also connect to our API and manage users for the dashboards you create. Or work with our Market Ready Dashboards and drive on autopilot.