Duplicate value from any Column

• Sandeep Mahajan-393729

  SSC Eights!

  Points: 858

  More actions

  April 5, 2007 at 12:13 am

  #177559

  Hi all,

  How to get duplicate value from any column...

  suppose i hv a Table 'tblAuthorArticle'

  and three cols. AuthorArticleID, AuthorID, ArticleID

  how to get duplicate ArticleID...

  plz help...it's Urgent

• rukmang rege

  SSC Journeyman

  Points: 97

  More actions

  April 5, 2007 at 12:35 am

  #698721

  Hi,

  You can try following

   

  select

  ArticleID from tblAuthorArticle group by ArticleID having count(ArticleID )>1