Welcome to ICONICS Automation Suite
Release Notes
Getting Started
Advanced Security
GENESIS64 Suite
AnalytiX Suite
    Welcome to AnalytiX
    BI Server
       About AnalytiX-BI Server
       AnalytiX-BI Configuration
       Data Flows
       Data Models
       AnalytiX-BI Runtime
       AnalytiX-BI SQL Language
          Data Types
          Culture and Collation
          Compatibility Level
          SELECT
             Using SELECT to retrieve rows and columns
             Automatically generated aliases
             Using SELECT with calculations and scalar functions
             Using SELECT with DISTINCT
             Using SELECT with TOP
             Using SELECT with OVER
                Using SELECT with OVER
                ROWS/RANGE
                Aggregates
                Ranking Functions
                Analytic Functions
                   FIRST_VALUE
                   LAST_VALUE
                   LAG
                   LEAD
          FROM
          JOIN
          GROUP BY
          WHERE
          HAVING
          ORDER BY
          Aggregate Functions
          UNION [ALL]
          COLLATE
          CASE
          Hierarchical Columns
          PIVOT
          Comments
          Scalar Functions
       Performance Considerations
       Point Manager Parameters
       Support for Query Interface and Table Control
    BridgeWorX64
    CFSWorX
    Energy AnalytiX
    Quality AnalytiX
    ReportWorX64
Hyper Historian
MobileHMI
IoTWorX
Workbench
Common Tools
Contact Us
Switch to Version 10.97.1 Help
Switch to Version 10.97 Help
Switch to Version 10.96.2 Help
Switch to Version 10.96.1 Help
Switch to Version 10.96 Help