Selecting distinct records in an SQL database through the Let’s learn how the Let\u2019s design a database for global smartphone sales to understand better how selecting distinct records from a table can help us extract insights from our dataset.<\/p>\n\n\n\n Our database has five fields (and many more in reality):<\/p>\n\n\n\n Here is what our database table would look like with five records in it:<\/p>\n\n\n\n Let’s say we want to find out which distinct brands are in this dataset. <\/p>\n\n\n\n By writing a SELECT DISTINCT<\/code> statement is a helpful and frequently used database query. The SELECT DISTINCT <\/code>statement returns only distinct values, which enables database administrators to get a quick overview of database records and generate insights from data.<\/p>\n\n\n\nSELECT DISTINCT<\/code> statement works, and how to combine it with other frequently used statements such as COUNT <\/code>or a WHERE <\/code>statement. We will illustrate the SELECT DISTINCT<\/code> statement with an easy-to-understand example.<\/p>\n\n\n\n
\n\n\nTable of Contents<\/h2><\/div>
\n\n\n\nSELECT DISTINCT Rows in SQL: Here’s How<\/h2>\n\n\n\n
\n
GUID<\/strong><\/td> Brand<\/strong><\/td> Manufacturer<\/strong><\/td> Model<\/strong><\/td> Month<\/strong><\/td> Units Sold<\/strong><\/td><\/tr> 1<\/td> Apple<\/td> Foxconn<\/td> iPhone X<\/td> January<\/td> 500<\/td><\/tr> 2<\/td> Samsung<\/td> Samsung Electronics<\/td> S22<\/td> January<\/td> 2000<\/td><\/tr> 3<\/td> Apple<\/td> Foxconn<\/td> iPhone 13 Pro<\/td> January<\/td> 800<\/td><\/tr> 4<\/td> Xiaomi<\/td> Xiaomi<\/td> Mi 11<\/td> December<\/td> 4500<\/td><\/tr> 5<\/td> Apple<\/td> Foxconn<\/td> iPhone 14 Plus<\/td> July<\/td> 5000<\/td><\/tr> 6<\/td> Samsung<\/td> Samsung Electronics<\/td> A55<\/td> December<\/td> 4500<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\nSELECT DISTINCT <\/code>statement, we can use SQL to return only distinct brands from the “Brand” column.<\/p>\n\n\n\n