SQL SELECT DISTINCT Statement - SQL TUTORIAL

SQL Select Distinct:

SQL SELECT DISTINCT query is used to return only unique values. It eliminates all the duplicated values.

Syntax:

SELECT DISTINCT column_name,column_name FROM table_name;

1	SELECT DISTINCT column_name,column_name FROM table_name;

Example:

SELECT DISTINCT Fours FROM SCOREBOARD;

1	SELECT DISTINCT Fours FROM SCOREBOARD;

In the below image, you could find two SELECT queries.

Total number of records displayed in the result are 3 related to the first SELECT query whereas the total number of records displayed in the result are 2 related to the second SELECT query. We used a DISTINCT keyword in the second SELECT query, so all the duplicate values are eliminated and returned only the unique values.

In the next tutorial, we will see Union & Union All In SQL

Check out the complete SQL Tutorial by clicking on below link:

SQL Tutorial – Complete

SQL SELECT DISTINCT Statement – SQL TUTORIAL | Software Testing Material

SQL Select Distinct:

Subscribe to get Free eBook and regular updates on Software Testing

About the Author

Comments

TUTORIALS

INTERVIEW QUESTIONS

TESTING TOOLS