When the SELECT clause in the create view statement contains the keyword DISTINCT, the view can be used to update data.

Name: When the SELECT clause in the create view statement contains the keyword DISTINCT, the view can be used to update data.
Brand: Quizplus
Rating: 4.8 (39 reviews)

Question

Quizplus · Accepted Answer

The use of DISTINCT in a view's SELECT clause makes the view non-updatable because it prevents the database from determining which specific rows to update.

When the SELECT Clause in the Create View Statement Contains