Deciphering The Keyword in SQL

SQL's unique `DISTINCT` term` is an essential tool for obtaining only the unique rows from a query result. Imagine you have a table of customers, and you desire to know how many different cities are represented. Using `SELECT city FROM customers;` would likely provide a enumeration with repeated city labels. However, `SELECT DISTINCT city FROM cust

read more