Distinct question, waiting on line, thanks

• halifaxdal

  SSCoach

  Points: 19741

  More actions

  March 23, 2007 at 8:40 am

  #62285

  Hi Folks,

  I have table: field1, f2, f3, f4, ... , f10

  f8-f10 are text field

  some of the records in the table are duplicated so I need to select based on the f1 to f7

  How do I write my select query?

  Thanks.

• Mark Harr

  SSCrazy Eights

  Points: 9921

  More actions

  March 23, 2007 at 11:29 am

  #696679

  What do you want the query to do?  Are you looking to get rid of duplicates?  Or just find duplicates?  Or list out everything except for duplicates?

  
  
  Mark

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736162

  More actions

  March 23, 2007 at 12:22 pm

  #696692

  please don't cross post.

  More discussion here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=353532