Re: SELECT duplicate set of rows

2006-08-10 Thread Chris
James Neff wrote: Greetings, I need help with a select statement that finds duplicate sets of rows. I have a table like so: batch_data --- ID - int (auto inc) Record ID - int DataValue - VarChar(99) DataType - int With a sample of data like this: 1 100 1122A 1 2

SELECT duplicate set of rows

2006-08-04 Thread James Neff
Greetings, I need help with a select statement that finds duplicate sets of rows. I have a table like so: batch_data --- ID - int (auto inc) Record ID - int DataValue - VarChar(99) DataType - int With a sample of data like this: 1 100 1122A 1 2 100 1350G 1 3