select fld from tbl group by fld having count(*) > 1 ?
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.
i have two fields, field1 which is an integer and field2 which is text, how do i select all documents in a table that have duplicate values or is not unique and sorted based on their corresponding field1 integer values?
thanks again.
quote: select fld from tbl group by fld having count(*) > 1 ?
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.
Select question
Posted - 11/11/2002 : 12:18:59
Thanks for the quick reply!