Eliminating duplicate rows from result-set using PostgreSQL

April 7, 2018 7 sec read

Use the DISTINCT ON keyword in your query
To do a case-insensitive search do the following query
SELECT DISTINCT ON(upper(surname)) surname FROM employees ORDER BY upper(surname)
This will return non-duplicate surnames.

Last Updated On April 07, 2018

« How to import a CSV file into a PostgreSQL database table

How to create a backup of a PostgreSQL database to a SQL file »

Leave a Reply

Subscribe