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)