{"id":174185,"date":"2026-02-19T20:40:13","date_gmt":"2026-02-19T19:40:13","guid":{"rendered":"https:\/\/liora.io\/en\/?p=174185"},"modified":"2026-02-19T20:40:14","modified_gmt":"2026-02-19T19:40:14","slug":"sql-distinct-how-do-i-use-this-query","status":"publish","type":"post","link":"https:\/\/liora.io\/en\/sql-distinct-how-do-i-use-this-query","title":{"rendered":"SQL DISTINCT: How do I use this query?"},"content":{"rendered":"

While the SELECT query is one of the most commonly used to read data from a table, it has some limitations if used on its own. That’s why other commands are associated with it. These combinations allow you to refine the results. One of these commands is SQL DISTINCT, which removes duplicates within a MySQL database.<\/strong><\/p>\t\t\n\t\t\t

What is SQL DISTINCT?<\/h2>\t\t\n\t\t

The SQL DISTINCT query<\/strong> is used to eliminate duplicates. When you use the SELECT SQL query,<\/a> you can choose one or more columns from a table. However, within these columns, there may be duplicate rows. To avoid this, you can add DISTINCT to the SELECT query. By doing so, all redundancies are removed.<\/p>

In practice, this command looks like this:<\/p>

SELECT DISTINCT column_name<\/p>

FROM table_name<\/p>

You can use this command on a single column or on a set of related columns.<\/p>

?Good to know:<\/strong> If you are using an Oracle database management system, you should not use the SQL DISTINCT command but rather the UNIQUE command.<\/p>\t\t\n\t\t\t

3 examples of using SQL DISTINCT<\/h2>
\"Three<\/figure>\t\t\n\t\t

To help you better understand how to use the SQL DISTINCT query, here are 3 concrete application examples.<\/p>\t\t\n\t\t\t

The SELECT DISTINCT query for a single column<\/h3>\t\t\n\t\t

This is the basic use of the SQL DISTINCT query.<\/p>

In our example, you have a table with all your customers, some of whom belong to the same family (same last name).<\/p>

Here is your table:<\/p>\t\t\n\t\t\t\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-9ix1{background-color:#6434fc;color:#efefef;font-size:20px;font-weight:bold;text-align:center;vertical-align:top}\n\n\n\n\n\n\n<\/colgroup>\n\n \n \n \n \n \n \n \n
ID<\/th>\n First Name<\/th>\n Last Name<\/th>\n <\/tr>\n<\/thead>\n
1<\/td>\n Pierre<\/td>\n Dupont<\/td>\n <\/tr>\n
2<\/td>\n Jeanne<\/td>\n Martin<\/td>\n <\/tr>\n
3<\/td>\n Henri<\/td>\n Durand<\/td>\n <\/tr>\n
4<\/td>\n Bertrand<\/td>\n Petit<\/td>\n <\/tr>\n
5<\/td>\n Martine<\/td>\n Dupont<\/td>\n <\/tr>\n<\/tbody>\n<\/table>\n\t\t

If you want to display only unique last names (families), here is the query to use: SELECT DISTINCT last_name FROM client<\/code>.<\/p>

And here is the result:<\/p>\t\t\n\t\t\t\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-5t56{background-color:#6434fc;color:#efefef;font-size:20px;text-align:center;vertical-align:top}\n.tg .tg-lap0{font-size:100%;text-align:center;vertical-align:top}\n\n\n\n\n<\/colgroup>\n\n \n \n \n \n \n \n
Name<\/th>\n <\/tr>\n<\/thead>\n
Dupont<\/td>\n <\/tr>\n
Martin<\/td>\n <\/tr>\n
Durand<\/td>\n <\/tr>\n
Petit<\/td>\n <\/tr>\n<\/tbody>\n<\/table>\t\t\n\t\t

Here, the name Smith is displayed only once (as opposed to twice in the first table).<\/p>\t\t\n\t\t\t\n

Learn SQL for Data Science<\/a><\/div><\/div>\n\n\t\t\t

The SELECT DISTINCT query for multiple columns<\/h3>\t\t\n\t\t

As mentioned above, the DISTINCT command can also be used for multiple columns.<\/p>

Let’s take an example of a similar Customer table:<\/p>\t\t\n\t\t\t\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-5t56{background-color:#6434fc;color:#efefef;font-size:20px;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\n\n\n\n\n\n\n<\/colgroup>\n\n \n \n \n \n \n \n \n \n \n \n \n
ID<\/th>\n First Name<\/th>\n Last Name<\/th>\n <\/tr>\n<\/thead>\n
1<\/td>\n Martine<\/td>\n Dupont<\/td>\n <\/tr>\n
2<\/td>\n Jeanne<\/td>\n Martin<\/td>\n <\/tr>\n
3<\/td>\n Henry<\/td>\n Durand<\/td>\n <\/tr>\n
4<\/td>\n Bertrand<\/td>\n Petit<\/td>\n <\/tr>\n
5<\/td>\n Martine<\/td>\n Dupont<\/td>\n <\/tr>\n
6<\/td>\n Antoine<\/td>\n Martin<\/td>\n <\/tr>\n
7<\/td>\n Fabienne<\/td>\n Bernard<\/td>\n <\/tr>\n
8<\/td>\n Christelle<\/td>\n Robert<\/td>\n <\/tr>\n
9<\/td>\n Henri<\/td>\n Durand<\/td>\n <\/tr>\n<\/tbody>\n<\/table>\n\t\t

If you want to display only unique families, here’s the query to use: SELECT DISTINCT first name last name FROM customer.<\/p>

And here’s the result:<\/p>\t\t\n\t\t\t\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-5t56{background-color:#6434fc;color:#efefef;font-size:20px;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-lap0{font-size:100%;text-align:center;vertical-align:top}\n\n\n\n\n\n<\/colgroup>\n\n \n \n \n \n \n \n \n \n \n
Pr\u00e9nom<\/th>\n Nom<\/th>\n <\/tr>\n<\/thead>\n
Martine<\/td>\n Dupon<\/td>\n <\/tr>\n
Jeanne<\/td>\n Martin<\/td>\n <\/tr>\n
Henri<\/td>\n Durand<\/td>\n <\/tr>\n
Bertrand<\/td>\n Petit<\/td>\n <\/tr>\n
Antoine<\/td>\n Martin<\/td>\n <\/tr>\n
Fabienne<\/td>\n Bernard<\/td>\n <\/tr>\n
Christelle<\/td>\n Robert<\/td>\n <\/tr>\n<\/tbody>\n<\/table>\t\t\n\t\t

In this case, the Martine Dupont and Henry Durand lines have been eliminated.<\/p>\t\t\n\t\t\t

The number of unique values<\/h3>\t\t\n\t\t

If you want to know how many unique values your table contains, simply perform the following operation:<\/p>

SELECT COUNT(DISTINCT name) AS Number FROM Customer<\/p>

Most often, the SQL query DISTINCT is used with the COUNT command to count values. But you can add other aggregations to suit your needs. This will enable you to perform various mathematical or statistical operations, without taking duplicates into account.<\/p>\t\t\n\t\t\t

Alternatives to SQL DISTINCT<\/h2>
\"Computer<\/figure>\t\t\n\t\t

Other commands can be used to eliminate duplicates. In particular, GROUP BY \/ ORDER BY.<\/p>

In this context, the SQL query is as follows:<\/a><\/p>

SELECT lastname, firstname FROM `Customer` GROUP BY lastname, firstname ORDER BY lastname, firstname<\/p>

The result is exactly the same as with the query: SELECT DISTINCT firstname lastname FROM customer.<\/p>\t\t\n\t\t\t

Master SQL with Liora<\/h2>\t\t\n\t\t

The SQL programming language is packed with essential queries for manipulating data. If you’d like to deepen your knowledge in this area, join our training courses at Liora. These business-oriented courses will have you 100% operational by the end of the course.<\/p>\t\t\n\t\t\t\n

Become an SQL expert<\/a><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

While the SELECT query is one of the most commonly used to read data from a table, it has some limitations if used on its own. That’s why other commands are associated with it. These combinations allow you to refine the results. One of these commands is SQL DISTINCT, which removes duplicates within a MySQL […]<\/p>\n","protected":false},"author":76,"featured_media":207727,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"_acf_changed":false,"editor_notices":[],"footnotes":""},"categories":[2433],"class_list":["post-174185","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-ai"],"acf":[],"_links":{"self":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/174185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/users\/76"}],"replies":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/comments?post=174185"}],"version-history":[{"count":3,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/174185\/revisions"}],"predecessor-version":[{"id":207728,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/174185\/revisions\/207728"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media\/207727"}],"wp:attachment":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media?parent=174185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/categories?post=174185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}