What is SELECT DISTINCT Statement



In this tutorial we know about the SQL Select Distinct Statement, First talking about SQL Select Distinct Statement article you must read Introduction to SQL For Beginners and also know what is SQL Syntax. Also know about the SELECT Statement. With SELECT statement get all records from tables but when we want distinct records or value. So we use SQL SELECT DISTINCT statement. SQL stands for Structure query language in Relational Database Management System (RDBMS). SQL Syntax is the format in which data save, update, insert with the SQL commands.

What is SQL SELECT DISTINCT Statement?

SQL Select Statement mostly used for select or retrieve data from database. But when we need different values we use distinct statement. A database contain table objects, there are many tables or one table in the database. Table has contain many records but some records contain same values or we can say duplicate data. Select statement is used on tables for getting records which are saved and stored in result set. Tables contains data in the form of records in the format of rows and also contains fields called columns. Column have many duplicate values, for getting different values used distinct statement.


SELECT DISTINCT column1, column2,
FROM table_name;

In this select distinct syntax column1, column2 are the name of fields of the table named table_name. Fields name is which records you want to get from table. Here we get different values or unique data from table. SQL statement is also used for retrieve all records of the table.

You Must Read Also:

SQL Introduction For Beginners

How To Insert Records In Database Using C# Language

How to Remove Duplicate Data from Database

Know What is SQL Syntax

What Is SQL Select Statement

Leave a Comment