Note |
---|
SQL worksheets are available as of Datameer 7.2 |
...
SQL worksheets give you the ability to write SQL queries directly in a workbook. Use SQL worksheets to combine processes that might take several steps using the traditional interface.
Using SQL Worksheets
Open a SQL worksheet
Open a workbook, select Sheets from the menu bar and select Add SQL Sheet.
A new worksheet is added to your workbook with a multiline SQL editor instead of a formula editor.
...
Title | SQL command |
---|
Logic functions | |
Comparison functions | value1 = value2 value1 <> value2 value1 > value2 value1 >= value2 value1 < value2 value1 <= value2 value IS NULL value IS NOT NULL value1 IS DISTINCT FROM value2 value1 IS NOT DISTINCT FROM value2 value1 BETWEEN value2 AND value3 value1 NOT BETWEEN value2 AND value3 string1 LIKE string2 [ ESCAPE string3 ] string1 NOT LIKE string2 [ ESCAPE string3 ] string1 SIMILAR TO string2 [ ESCAPE string3 ] string1 NOT SIMILAR TO string2 [ ESCAPE string3 ] value IN (value [, value]*) value NOT IN (value [, value]*) value IN (sub-query) value NOT IN (sub-query) EXISTS (sub-query) NOT EXISTS (sub-query)
|
SQL logic | boolean1 OR boolean2 boolean1 AND boolean2 NOT boolean boolean IS FALSE boolean IS TRUE boolean IS NOT TRUE boolean IS UNKNOWN boolean IS NOT UNKNOWN
|
Numeric functions | |
String functions | string || string CHAR_LENGTH(string) CHARACTER_LENGTH(string) UPPER(string) LOWER(string) POSITION(string1 IN string2) - REPLACE (string_expression, string_pattern, string_replacement)
TRIM( { BOTH | LEADING | TRAILING } string1 FROM string2) SUBSTRING(string FROM integer) SUBSTRING(string FROM integer FOR integer)
|
Date/Time/Timestamp functions | |
Case functions | - CASE value
- CASE
- NULLIF(value, value)
- COALESCE(value, value [, value ]*)
|
Aggregation functions | - COUNT( [ ALL | DISTINCT ] value [, value ]*)
- COUNT(*)
- APPROX_COUNT_DISTINCT(value [, value ]*)
- AVG( [ ALL | DISTINCT ] numeric)
- SUM( [ ALL | DISTINCT ] numeric)
- MAX( [ ALL | DISTINCT ] value)
- MIN( [ ALL | DISTINCT ] value)
- STDDEV_POP( [ ALL | DISTINCT ] numeric)
- STDDEV_SAMP( [ ALL | DISTINCT ] numeric)
- VAR_POP( [ ALL | DISTINCT ] value)
- VAR_SAMP( [ ALL | DISTINCT ] numeric)
|
Set clauses | |
Join clauses | - INNER JOIN
- LEFT OUTER JOIN
- RIGHT OUTER JOIN
- FULL OUTER JOIN
- INNER JOIN (sub-query)
- LEFT OUTER JOIN (sub-query)
- RIGHT OUTER JOIN (sub-query)
- FULL OUTER JOIN (sub-query)
|
...