SQL: How to find duplicated values
2005-02-23 01:56:23 AM
cppbuilder15
I have a table (MS ACCESS) with 2 fields:
1 field: MyText (TEXT)
2 field: MyBool (BOOL)
...which both should make a primary key, but first I
have somehow to get rid of duplicates:
I need an SQL which can find duplicates for me by
any of those tools: SQL Explorer, MS Access Query or
BCB6&ADOQuery.
Also why this do not work with any of the tools mentioned:
// This is only for a single field, not for both
select MyText, count(MyText) as Counter
from SomeTable
group by MyText
where Counter>1
--
Best regards,
Vladimir Stefanovic