Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Sep 14, 1999

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.id
from mytable a
where a.title not in
(select b.title from mytable b)
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date