Home
Concept
User Manual
- About User Manual
- Client connectivity
  - Overview
  - Excel
  - PowerBI
  - Tableau
- Connections
- Databases
- Schemas
  - Manage schemas
- Tables
- Primary and Foreign Keys
  - Primary and Foreign Keys
- Views
- Indexes
  - Indexes
- Bulk operations
  - Overview
- Management tasks
  - Overview
- Business terms
  - Assign business term
- Search
  - Search screen
- Query
  - Query screen
Reference Guide
- Data providers
  - Overview
  - CSV/TSV
  - Kafka
  - JDBC
  - MySql
  - Oracle
  - SAP
  - SAP HANA
- SQL in Lyftron
  - SQL in Lyftron
- SQL Language Elements
  - Overview
  - Keywords
  - Identifier
  - Literals
  - Operators
  - Expressions
  - Predicates
- SQL Data Types
- Statements
  - Overview
  - CREATE DATABASE
- Functions
  - Overview
  - Aggregate
    - APPROX_COUNT_DISTINCT
    - AVG
    - CHECKSUM_AGG
    - COUNT_BIG
    - COUNT
    - GROUPING
    - GROUPING_ID
    - KURTOSIS
    - MAX
    - MIN
    - STDEV
    - STDEVP
    - SKEWNESS
    - SUM
    - VAR
    - VARP
  - Analytical
    - CUME_DIST
    - FIRST_VALUE
    - LAG
    - LAST_VALUE
    - LEAD
    - PERCENTILE_CONT
    - PERCENTILE_DISC
    - PERCENT_RANK
  - Azure
    - DETECT_FACES
    - USER_TO_ITEM_RECOMMENDATION
  - Date & time
    - DATEADD
    - DATEDIFF
    - DATEFROMPARTS
    - DATENAME
    - DATEPART
    - DATETIME2FROMPARTS
    - DATETIMEFROMPARTS
    - DAY
    - EOMONTH
    - GETDATE
    - GETUTCDATE
    - ISDATE
    - MONTH
    - SMALLDATETIMEFROMPARTS
    - SYSDATETIME
    - SYSUTCDATETIME
    - TIMEFROMPARTS
    - YEAR
  - Expression
    - COALESCE
    - IIF
    - ISNULL
    - NULLIF
  - Math
    - ABS
    - ACOS
    - ASIN
    - ATAN
    - ATN2
    - CEILING
    - COS
    - COT
    - DEGREES
    - EXP
    - FLOOR
    - LOG10
    - LOG
    - PI
    - POWER
    - RADIANS
    - RAND
    - ROUND
    - SIGN
    - SIN
    - SQRT
    - SQUARE
    - TAN
  - Metadata
    - QUA_PARTITION_HINT
  - Ranking
    - DENSE_RANK
    - NTILE
    - RANK
    - ROW_NUMBER
  - String
    - ASCII
    - CHAR
    - CHARINDEX
    - CONCAT
    - FORMAT
    - LEFT
    - LEN
    - LEVENSHTEIN
    - LOWER
    - LTRIM
    - NCHAR
    - PATINDEX
    - QUOTENAME
    - REPLACE
    - REPLICATE
    - REVERSE
    - RIGHT
    - RTRIM
    - SPACE
    - SPLIT
    - STR
    - STUFF
    - SUBSTRING
    - UNICODE
    - UPPER
  - System
  - Tabular
    - FN_BUILTIN_PERMISSIONS
    - FN_HELPCOLLATIONS
  - Data pseudonymization
    - QUA_SHUFFLE
    - QUA_DESHUFFLE
- Stored procedures
  - About stored procedures
    - Overview
  - Administrative
  - Cache management
  - Connection management
  - Diagnostics
    - lyft_set_logging_level
    - lyft_help_jobs
  - Job management
  - Utility
  - Metadata management
  - Spark management
- Non-standard views
- Caching and partitioning
Monitoring
Administrators Guide
- Administration Overview
- Access Rights
- Business terms
- Engine configuration
- Jobs and Schedules
- Logging
- Spark management
  - Overview
  - Spark database migration
- SQL dialects
- Users and Roles
Installation Guide
- Getting Started
- Requirements
- Components
- Prerequisites
  - Installation prerequisites
  - Installation of SQL Server engine
- Installation
- Manual installation of metabases
- Configuration
- Upgrade

Lyftron™ product documentation

Docs »
Reference Guide »
SQL in Lyftron

SQL in Lyftron

Lyftron supports SQL that is compatible with Transact-SQL. This document describes all supported statements, functions, data types and stored procedures.

© Lyftron 2018, All rights reserved. Lyftron, Microsoft, SQL Server, Apache, Apache Sparkare all registered trademarks of their respective owners.

The documentation was built on 2019-06-26.

« Previous Next »