Which modifier should be used to remove duplicate rows in SQL query?

Which modifier should be used to remove duplicate rows in SQL query?

From the DESCO Assistant Engineer (CSE) 2016 – Written exam, question 2 of 11.

More from this paper