This query will insert all the data of the table LateralStudent in the table Student. INSERT INTO Student SELECT * FROM LateralStudent
The difference is that the SELECT statement is used here to select data from a different table. We can use the SELECT statement with INSERT INTO statement to copy rows from one table and insert them into another table.The use of this statement is similar to that of INSERT INTO statement.