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.
SELECT key1... FROM logstore1 INTERSECT SELECT key2... FROM logstore2
- 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.
|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.|
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 results