VALUES keyword can not be used with a subquery

It looks like you have a very big chance of getting this question on your exam.

In first insert statement, we just created the first row by using standard syntax.

In second insert statement we’ve tried to insert same values but using subquery and it failed.

You should have used third insert statement in order to have values be inserted through a subquery. Just remove VALUES keyword and it will work.


Leave a comment

Your email address will not be published. Required fields are marked *