For the latest version of JMP Help, visit JMP.com/help.


JSL Syntax Reference > SQL Functions Available for JMP Queries
Publication date: 06/21/2023

SQL Functions Available for JMP Queries

The Query() JSL function performs a SQL query on selected tables and exports the data to a data table. The following example first assigns the t1 alias to Big Class.jmp. name, age greater than 13, and height are then selected from the t1 table.

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
Query( Table( dt, "t1" ),
       "SELECT t1.name, t1.age, t1.height FROM t1
       WHERE t1.age > 13" );

You can use SQL functions in a query. For example, SELECT CURRENT_TIMESTAMP returns the current UTC/GMT time stamp as a SQLite time string:

Query( Scalar, "SELECT CURRENT_TIMESTAMP;" );

This appendix lists the numeric, date-time, string, system SQL, and aggregate functions that you can use in SQL queries. “Yes” in the SQLite column indicates native SQLite functions. See the Online SQLite documentation at https://www.sqlite.org/lang.html.

Contents

Numeric SQL Functions

Date-Time SQL Functions

String SQL Functions
System SQL Functions

Aggregate SQL Functions

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).