CAT DOCS
Browse docs
    • Introduction
    • CAT use-cases
    • How CAT works?
    • CAT in your infrastructure
    • Test examples
    • Need more info?
    • How to get started?
      • Install CAT studio
      • Explore sample project
      • Create first test
      • Install CAT CLI
      • Explore sample project
      • Create first test
      • Install PowerShell module
      • Explore sample project
      • Create first test
    • What next?
      • Introduction
      • Prerequisites
      • Install CAT
      • What Do I Have Installed?
      • Upgrade
      • Uninstall CAT
      • Introduction
      • Data Source
      • Test Definition
      • Naming Conventions
      • Project Files Introduction
      • Create a Project File
      • Execute Tests
      • Load Tests from ...
      • Run Tests in Parallel
      • Generate tests
      • Environment variables
      • Introduction
      • Overview
      • Set is Empty
      • Set is not Empty
      • Set RowCount
        • Introduction
        • Maximum Errors Logged
        • Sets Match - Error Message
        • Sets Match - Using Key
      • Contains
      • Introduction
      • Overview
      • Csv@1
      • Csv@2
      • CsvOleDB@1
      • Dax@1
      • Excel@1
        • Introduction
        • SELECT syntax
        • JOINs and set operations
        • Expressions
        • Functions
      • ExcelOleDB@1
      • MySql@1
      • Odbc@1
      • Oracle@1
      • Postgres@1
      • PowerBI@1
      • Snowflake@1
      • SqlServer@1
      • SqlServer@2
      • Yaml@1
      • Introduction
      • Output Settings
      • Output Formats
      • Output Properteis
      • XLSX
      • JSON
      • JUnit
      • TRX
      • YAML
      • SQL Server
      • ORACLE
      • PostgreSQL
      • Introduction
      • Import Module
      • List of Commands
      • Get Help
      • Creating a project
      • Working with a Project
      • Running tests
      • Invoke Command
      • Other Commands
      • Introduction
      • new
      • show
      • run
      • open
      • exec
      • docs
      • instance
      • Introduction
      • Installation
      • Run tests
      • Introduction
      • Azure DevOps
      • GitLab
      • GitHub Actions
      • Jenkins
    • Troubleshooting
    • Get CAT License
    • Apply a License Key
    • Work with Passwords
    • Test Power BI
    • DAX introduction
    • GUI for DAX queries
    • Test Databricks
    • Azure DevOps Classic Releases
    • SQL Server Agent
    • CAT on Linux
      • CAT 1.9.0
      • CAT 1.8.0
      • CAT 1.7.0
      • CAT 1.6.0
      • CAT 1.5.0
      • CAT 1.4.0
      • CAT 1.3.0
      • CAT 1.2.0
      • CAT 1.1.0
      • CAT 1.0.0
      • CAT 0.28.0
      • CAT 0.27.0
      • CAT 0.26.0
      • CAT 0.25.0
      • CAT 0.24.0
      • CAT 0.23.0
      • CAT 0.22.0
      • CAT 0.21.0
      • CAT 0.20.0
      • CAT 0.19.0
      • CAT 0.18.0
      • CAT 0.17.0
      • CAT 0.16.0
      • CAT 0.15.0
      • CAT 0.14.0
      • CAT 0.13.0
      • CAT 0.12.0
      • CAT 0.11.0
      • CAT 0.10.0
      • CAT 0.9.1
      • CAT 0.9.0
      • CAT 0.8.0
      • CAT 0.7.0
      • CAT 0.6.0
      • CAT 0.5.0
      • CAT 0.4.0
      • CAT 0.3.0
      • CAT 0.2.0
      • CAT 0.1.0
      • CAT 0.0.2
      • CAT 0.0.1

CAT DOCS

  • Get Started
    • What is CAT
    • CAT use-cases
    • How CAT works
    • Start using CAT
  • Full documentation
  • What's new
  • Compare plans
  • More
    • Releases
    • License
    • Privacy policy
    • Roadmap
    • Introduction
    • CAT use-cases
    • How CAT works?
    • CAT in your infrastructure
    • Test examples
    • Need more info?
    • How to get started?
      • Install CAT studio
      • Explore sample project
      • Create first test
      • Install CAT CLI
      • Explore sample project
      • Create first test
      • Install PowerShell module
      • Explore sample project
      • Create first test
    • What next?
      • Introduction
      • Prerequisites
      • Install CAT
      • What Do I Have Installed?
      • Upgrade
      • Uninstall CAT
      • Introduction
      • Data Source
      • Test Definition
      • Naming Conventions
      • Project Files Introduction
      • Create a Project File
      • Execute Tests
      • Load Tests from ...
      • Run Tests in Parallel
      • Generate tests
      • Environment variables
      • Introduction
      • Overview
      • Set is Empty
      • Set is not Empty
      • Set RowCount
        • Introduction
        • Maximum Errors Logged
        • Sets Match - Error Message
        • Sets Match - Using Key
      • Contains
      • Introduction
      • Overview
      • Csv@1
      • Csv@2
      • CsvOleDB@1
      • Dax@1
      • Excel@1
        • Introduction
        • SELECT syntax
        • JOINs and set operations
        • Expressions
        • Functions
      • ExcelOleDB@1
      • MySql@1
      • Odbc@1
      • Oracle@1
      • Postgres@1
      • PowerBI@1
      • Snowflake@1
      • SqlServer@1
      • SqlServer@2
      • Yaml@1
      • Introduction
      • Output Settings
      • Output Formats
      • Output Properteis
      • XLSX
      • JSON
      • JUnit
      • TRX
      • YAML
      • SQL Server
      • ORACLE
      • PostgreSQL
      • Introduction
      • Import Module
      • List of Commands
      • Get Help
      • Creating a project
      • Working with a Project
      • Running tests
      • Invoke Command
      • Other Commands
      • Introduction
      • new
      • show
      • run
      • open
      • exec
      • docs
      • instance
      • Introduction
      • Installation
      • Run tests
      • Introduction
      • Azure DevOps
      • GitLab
      • GitHub Actions
      • Jenkins
    • Troubleshooting
    • Get CAT License
    • Apply a License Key
    • Work with Passwords
    • Test Power BI
    • DAX introduction
    • GUI for DAX queries
    • Test Databricks
    • Azure DevOps Classic Releases
    • SQL Server Agent
    • CAT on Linux
      • CAT 1.9.0
      • CAT 1.8.0
      • CAT 1.7.0
      • CAT 1.6.0
      • CAT 1.5.0
      • CAT 1.4.0
      • CAT 1.3.0
      • CAT 1.2.0
      • CAT 1.1.0
      • CAT 1.0.0
      • CAT 0.28.0
      • CAT 0.27.0
      • CAT 0.26.0
      • CAT 0.25.0
      • CAT 0.24.0
      • CAT 0.23.0
      • CAT 0.22.0
      • CAT 0.21.0
      • CAT 0.20.0
      • CAT 0.19.0
      • CAT 0.18.0
      • CAT 0.17.0
      • CAT 0.16.0
      • CAT 0.15.0
      • CAT 0.14.0
      • CAT 0.13.0
      • CAT 0.12.0
      • CAT 0.11.0
      • CAT 0.10.0
      • CAT 0.9.1
      • CAT 0.9.0
      • CAT 0.8.0
      • CAT 0.7.0
      • CAT 0.6.0
      • CAT 0.5.0
      • CAT 0.4.0
      • CAT 0.3.0
      • CAT 0.2.0
      • CAT 0.1.0
      • CAT 0.0.2
      • CAT 0.0.1

Excel@2

Expressions →
Functions →
Introduction →
JOINs and Set Operations →
SELECT Syntax →
  • © Data Tools s.r.o.
  • License
  • Privacy policy
  • Compare plans
  • Roadmap