Comprehending The Keyword in SQL

SQL's distinct `DISTINCT` term` is an crucial tool for obtaining only the different rows from a query result. Imagine you have a table of customers, and you desire to know how many several cities are listed. Using `SELECT city FROM customers;` would potentially give a list with duplicative city names. However, `SELECT DISTINCT city FROM customers;`

read more