The Insert Into Select statement

The INSERT INTO SELECT statement copies data from one table and inserts it into another table. This statement requires that the data types in source and target tables matches. The existing records in the target table are unaffected. SYNTAX ISNERT INTO table 2 SELECT * FROM table 1 WHERE condition; One can also copy only...

EXISTS, ANY, ALL

EXISTS: The EXISTS operator is used to check the existence of record in the subquery. It returns TRUE if the subquery returns one or more records. SYNTAX: SELECT column name(s) FROM table name WHERE EXISTS (SELECT column name FROM table name WHERE condition); ANY & ALL : These operators allow you to perform a comparison...