Prev Next

MySQL DISTINCT

The DISTINCT keyword is used to return unique values from a column, eliminating duplicate entries. It is useful for summarizing or analyzing distinct data points.

Examples with Tamil Kings

1. Selecting Unique Kingdoms

SELECT DISTINCT kingdom FROM tamil_kings_auto_increment;

Code Explanation: This query returns a list of unique kingdoms from the tamil_kings_auto_increment table.

2. Selecting Unique Reign Periods

SELECT DISTINCT reign_period FROM tamil_kings_auto_increment;

Code Explanation: This query returns a list of unique reign periods from the tamil_kings_auto_increment table.

Best Practices

  • Use DISTINCT to eliminate duplicates and simplify data analysis.
  • Combine DISTINCT with multiple columns to get unique combinations of values.

Key Takeaways

  • The DISTINCT keyword removes duplicate values from the result set.
  • It is useful for summarizing or analyzing distinct data points.
Prev Next