PostgreSQL - SELECT DISTINCT

Introduction

In this tutorial, we want to select data from a table by using a SQL Statement. The result should not contain duplicate rows. In order to do this, we use the SELECT Statement with the DISTINCT Clause.

We have already created the table student with the following data:

Example 1

We want to select the unique values from the column gender.

In order to do this, we execute the following SQL statement:

SELECT DISTINCT gender
FROM student;

The following selection is returned:

Example 2

Now, we want to select the unique value pairs from the columns name and gender.

In order to do this, we execute the following SQL statement:

SELECT DISTINCT name, gender
FROM student;

The following selection is returned:

Conclusion

Congratulations! Now you are one step closer to become an AI Expert. You have seen that it is very easy to select data from a table without dublicate rows. We can simply use the SELECT Statement with the DISTINCT Clause. Try it yourself!