How To Use Distinct Keyword In SQL

Introduction

In this article, we will learn how to use the DISTINCT keyword with a SQL select query.

Inside a table, a column may contain many duplicate values; To select only different (distinct) values from a database in SQL SELECT DISTINCT statement is used.

Syntax

SELECT DISTINCT column1, column2, ...columnN
FROM TABLE_NAME;

Example

The subsequent statement would return only the DISTINCT values from the Title field in the Article table.

SELECT DISTINCT Title FROM Article;

Also, check How To Write Select Query In SQL

Yasin Panwala

Yasin Panwala is a Web Developer and Author at TheCodeHubs. He has experience in Web Developing and Designing and also in Writing. He has got his skills in working on technologies like .NET Core, ADO.NET, AJAX, Angular, AngularJS, ASP.NET, ASP.NET MVC, Bootstrap, C#, CSS, Entity Framework, Express.js, GraphQL, HTML, JavaScript, JQuery, JSON, LINQ, Microsoft Office, MongoDB, MySQL, Node.js, PostgreSQL, SQL, SQL Server, TypeORM, TypeScript, Visual Basic .NET, Web API. He also got his skills in working with different integration and some known versioning tools. He is always ready to learn new things and he always tries his best on tasks that are assigned to him and gives the best possible outputs.