Question

Which of the above syntax should be used when we are not sure of the order (with respect to the column) in which the values are to be inserted in the table?

Answer 1

INSERT INTO STUDENT (RollNumber, SName, SDateofBirth, GUID)
VALUES (value1, value2, value3, value4);