ADQL Reference:

Your Rating:
Results:
PatheticBadOKGoodOutstanding!
16 rates

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.

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’)

 

  • No labels