# SQL Quick Reference

> A quick overview of how you can use SQL to create new tables and fields in Sisense.

*Source: https://docs.sisense.com/main/SisenseLinux/sql-reference.htm*

---

Last updated: June 11, 2026

|  |  |
| --- | --- |
| [Tier](https://www.sisense.com/pricing/#pricing) | [Deployment](https://docs.sisense.com/main/SisenseLinux/introduction-to-sisense-cloud-managed-services.md#ComparisonofManagedCloudandSelfHosted) |
| Launch     Grow    Enterprise | Cloud     On-Prem |

This topic provides a quick overview of how you can use SQL to create new tables and fields in Sisense.

## Basic SQL Syntax Guide

### Select Statements

SELECT

SELECT column\_name(s)  
FROM table\_name

SELECT \*

SELECT \* FROM table\_name

SELECT DISTINCT

SELECT DISTINCT column\_name(s)  
FROM table\_name

**Note:**

Nested SELECT statements will not work with an AND clause in Sisense.

### Functions After Select Clause

- `AVG()` - Returns the average value
- `COUNT()` - Returns the number of rows
- `MAX()` - Returns the largest value
- `MIN()` - Returns the smallest value
- `SUM()` - Returns the sum

### Table Join Functions

**INNER JOIN**

SELECT column\_name(s)
  
FROM table\_name1 T1
  
INNER JOIN table\_name2 T2
  
ON T1.column\_name=T2.column\_name

**LEFT JOIN**

SELECT column\_name(s)
  
FROM table\_name1 T1
  
LEFT JOIN table\_name2 T2
  
ON T1.column\_name=T2.column\_name

**RIGHT JOIN**

SELECT column\_name(s)
  
FROM table\_name1 T1
  
RIGHT JOIN table\_name2 T2
  
ON T1.column\_name=T2.column\_name

**FULL JOIN**

SELECT column\_name(s)
  
FROM table\_name1 T1
  
FULL JOIN table\_name2 T2
  
ON T1.column\_name=T2.column\_name

**AS (alias)**

SELECT column\_name AS column\_alias
  
FROM table\_name

or

SELECT column\_name
  
FROM table\_name AS table\_alias

**WHERE**

SELECT column\_name(s)
  
FROM table\_name
  
WHERE column\_name operator value

### Functions After the Where Clause

**AND / OR**

SELECT column\_name(s)
  
FROM table\_name
  
WHERE condition AND|OR condition

**BETWEEN**

SELECT column\_name(s)
  
FROM table\_name
  
WHERE column\_name
  
BETWEEN value1 AND value2

**IN**

SELECT column\_name(s)
  
FROM table\_name
  
WHERE column\_name
  
IN (value1,value2,..)

LIKE

SELECT column\_name(s)
  
FROM table\_name
  
WHERE column\_name LIKE pattern

### Ordering and Grouping After Where Conditions

GROUP BY

SELECT column\_name,
  
aggregate\_function(column\_name)
  
FROM table\_name
  
WHERE column\_name operator value
  
GROUP BY column\_name

**ORDER BY**

SELECT column\_name(s)
  
FROM table\_name
  
ORDER BY column\_name [ASC|DESC]

**HAVING**

SELECT column\_name,
  
aggregate\_function(column\_name)
  
FROM table\_name
  
WHERE column\_name operator value
  
GROUP BY column\_name
  
HAVING aggregate\_function(column\_name) operator value

### Clauses for Combining Tables

UNION

SELECT column\_name(s) FROM table\_name1
  
UNION
  
SELECT column\_name(s) FROM table\_name2

**UNION ALL**

SELECT column\_name(s) FROM table\_name1
  
UNION ALL
  
SELECT column\_name(s) FROM table\_name2

### Example SQL Query

Below is a side-by-side example of an SQL query with some SQL main clauses next to the corresponding syntax.

| SQL Example | Corresponding SQL Syntax |
| --- | --- |
| ``` SELECT CustomerLastName, CustomerName, ContactEmail, Count(OrderID) AS Counter ```  ``` FROM Customers c ```  ``` INNER JOIN Order o ```  ``` ON c.CustomerID = o.CustomerID ```  ``` WHERE ```  ``` o.OrderId BETWEEN 10 AND 100 AND ```  ``` (c.CustomerName IN ('John','Mary','David') OR c.CustomerLastName LIKE 'Harrison%') ```  ``` GROUP BY c.CustomerLastName, c.CustomerName, c.ContactEmail ```  ``` HAVING Count(o.OrderID) > 3 ```  ``` ORDER BY c.CustomerLastName, c.CustomerName ``` | ``` SELECT FieldName(s),Function(), * ```  ``` FROM TableName 1 ```  ``` INNER JOIN\ LEFT JOIN\RIGHT JOIN\FULL JOIN TableName 2 ```  ``` ON TableName 1. JoinField = TableName 2. JoinField ```  ``` WHERE FieldName Condition ```  ``` AND\OR FieldName Condition ```  ```   ```  ``` GROUP BY FieldName(s) ```  ``` HAVING FieldName(s) Condition ```  ``` ORDER BY FieldName(s) ``` |

### Other SQL Reference Documentation

The [Snowflake SQL Command Reference](https://docs.snowflake.com/en/sql-reference-commands) documentation can provide additional detail regarding the use of SQL and SQL syntax.