CAT DOCS
Browse docs
      • Get Started in 4 Simple Steps
      • Register CAT
      • Get CAT License
      • Apply a License Key
      • Work with Passwords
      • Test Power BI
      • Test Databricks
      • Azure DevOps Classic Releases
      • 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
      • Introduction
      • Overview
      • Set is Empty
      • Set is not Empty
      • Set RowCount
        • Introduction
        • Maximum Errors Logged
        • Sets Match - Error Message
        • Sets Match - Using Key
      • Introduction
      • Overview
      • Csv@1
      • CsvOleDB@1
      • Dax@1
      • Excel@1
        • Introduction
        • SELECT syntax
        • JOINs and set operations
        • Expressions
        • Functions
      • ExcelOleDB@1
      • Odbc@1
      • Oracle@1
      • Postgres@1
      • PowerBI@1
      • SqlServer@1
      • Yaml@1
      • Introduction
      • Output Settings
      • Output Formats
      • XLSX
      • JSON
      • JUnit
      • TRX
      • YAML
      • SQL Server
      • ORACLE
      • Introduction
      • Import Module
      • List of Commands
      • Get Help
      • Working with a Project
      • Running tests
      • Test Results
      • Invoke Command
      • Other Commands
      • Introduction
      • show
      • run
      • open
      • exec
      • docs
      • instance
    • Troubleshooting
      • Introduction
      • Azure DevOps
      • GitLab
      • GitHub Actions
      • Jenkins
      • 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
    • Create your first test
  • Help
  • Release notes
  • Releases
      • Get Started in 4 Simple Steps
      • Register CAT
      • Get CAT License
      • Apply a License Key
      • Work with Passwords
      • Test Power BI
      • Test Databricks
      • Azure DevOps Classic Releases
      • 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
      • Introduction
      • Overview
      • Set is Empty
      • Set is not Empty
      • Set RowCount
        • Introduction
        • Maximum Errors Logged
        • Sets Match - Error Message
        • Sets Match - Using Key
      • Introduction
      • Overview
      • Csv@1
      • CsvOleDB@1
      • Dax@1
      • Excel@1
        • Introduction
        • SELECT syntax
        • JOINs and set operations
        • Expressions
        • Functions
      • ExcelOleDB@1
      • Odbc@1
      • Oracle@1
      • Postgres@1
      • PowerBI@1
      • SqlServer@1
      • Yaml@1
      • Introduction
      • Output Settings
      • Output Formats
      • XLSX
      • JSON
      • JUnit
      • TRX
      • YAML
      • SQL Server
      • ORACLE
      • Introduction
      • Import Module
      • List of Commands
      • Get Help
      • Working with a Project
      • Running tests
      • Test Results
      • Invoke Command
      • Other Commands
      • Introduction
      • show
      • run
      • open
      • exec
      • docs
      • instance
    • Troubleshooting
      • Introduction
      • Azure DevOps
      • GitLab
      • GitHub Actions
      • Jenkins
      • 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
  • References
  • Roadmap