QuestionQ118

VerifiedDatabase Fundamentals

A data analyst wants to select just one instance of each duplicated region in the chart below:

Question Image

Which of the following SQL commands should the data analyst use to accomplish this task?

Explanation

DISTINCT removes duplicate rows from a SELECT result, so selecting the Region column with SELECT DISTINCT returns each region only once.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!