Distinct Cities — Solution & ExplanationProblems / Distinct Cities / EditorialApproachSELECT DISTINCT removes duplicate values from the result.

SELECT DISTINCT city returns each city exactly once.

ORDER BY city sorts alphabetically.

DISTINCT operates on the entire selected row, so if you selected multiple columns, it would deduplicate based on the combination of all selected columns.Hints

DISTINCT eliminates duplicate rows from your result.

Place DISTINCT right after SELECT.

In PySpark, use .distinct() on a DataFrame.

Solve Distinct Cities yourself →