The INTERSECT clause is used to combine the result sets of two SELECT statements and return only rows that are common to the result sets of the two SELECT statements. This topic describes the syntax of the INTERSECT clause. This topic also provides examples on how to use the INTERSECT clause.

Syntax

SELECT key1... FROM logstore1
INTERSECT
SELECT key2... FROM logstore2
Notice
  • The number and order of the columns in the result sets of the two SELECT statements must be the same. The data types for the columns in the result sets of the two SELECT statements must be the same.
  • The INTERSECT clause removes all duplicates from the final results. This way, distinct values are returned in the final results.

Parameters

Parameter Description
key The field name, column name, or expression.

You can specify different values for key1 and key2, but you must specify the same data types for them.

logstore The name of the Logstore.

Examples

A Logstore named internal-diagnostic_log is used to store important logs. The important logs record information about the log consumption latency, alerts, and log collection of each Logstore. A Logstore named internal-operation_log is used to store detailed logs. The detailed logs record information about all the operations on resources in a project. You can use the INTERSECT clause to query which Logstores have both detailed logs and important logs.

  • Query statement
    * |
    SELECT
      logstore
    FROM  internal-operation_log
    INTERSECT
    SELECT
      logstore
    FROM  internal-diagnostic_log
  • Query and analysis resultsINTERSECT