Wednesday , April 24 2024

PostgreSQL Distinct

Distinct statement is an SQL statement that is used to show only one of several identical records in a table.

Let’s reinforce it with an example.

First, let’s create our table named distinctörneği.

Let’s add a record to the distinct table we created.

Let’s display the columns in our table by selecting the name column.

As seen above, faruk record has been added twice in our table, and we will ensure that the same record is received only one of them with the distinct command.

As seen in the example above, we are listing only one of the faruk records in our table.


About Faruk Erdem

Leave a Reply

Your email address will not be published. Required fields are marked *