DS0-001: CompTIA DataSys+Demo

By CompTIA · Question Mode

QuestionQ118

Database 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?

  • A SELECT COUNT()
  • B SELECT UNIQUE
  • C SELECT DISTINCT
  • D SELECT DIFFERENT
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!