PDFs

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: DOCS-1334

Appd tocbox
Width400px

ADQL Reference:

Page Tree
rootADQL Reference

Overview

Use the WHERE clause to specify one or more condition expressions separated by logical operators such as ANDOR. 

The WHERE clause uses the following syntax:

[WHERE condition_expression] 

See ADQL Expressions for a description of the condition expression syntax. Condition expressions use Comparison Operators.Example:

Examples

To filter logs based on error or warning log level, use a query similar to the following:

SELECT * FROM logs WHERE sourceType='yourLogFile' AND (logLevel=’ERROR’ OR logLevel=’WARN’)