Elimiating duplicate rows from result-set using Postgres

Question: How to remove duplicate rows in a result-set returned from a SELECT query using Postgres?

Answer:

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

• Add New Search
• Comments

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Comment:

Title:

UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge

Message:

Security

Please input the anti-spam code that you can read in the image.