Removing a Duplicated Item

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


    A 002
    B 003

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

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


Recent Articles: