Question

Create table emp and insert multiple records in it​

Answer 1

Answer:

How to insert multiple rows in SQL?

First way – Separating VALUES part by a comma.

Insert multiple records without specifying the column names.

Second Way – Using INSERT INTO & SELECT statements.

Third way: The UNION Operator.