Removing a Duplicated Item

Question:
I have tried the following code:

 SELECT distinct title, id from table where .....order by title

and it returns:

    A 001
    A 002
    B 003

The result I want is:

    A 001
    B 003

or

    A 002
    B 003

Item A is duplicated for storing extended detail. How can I make that work?

Answer:
I didn’t get to test this, but I think what is required is to do a self join to the table and look for an inequality on title or on ID to force the single instance out.

Something like this:

 select a.title, a.idfrom mytable awhere a.title not in(select b.title from mytable b)

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: