MINUS, INTERSECT and UNION usage

xiaoxiao2021-03-06  38

MINUS returns a record that appears in the first query and the record in the second query; INTERSECT returns a record in the two queries; Union returns the records of two queries

E.G: INSERT INTO TABLE3 (select * from table1 minus select * from table2) The function of the SQL statement on the top of the table is to insert the data present in Table1 but not in Table2 in the Table 3.

转载请注明原文地址:https://www.9cbs.com/read-69883.html

New Post(0)