Finding Duplicate rows

Posted in 2007

WA — Thu, 12 Jul 2007 02:00:52 -0700 — source: Usenet: comp.databases.informix

Hi, I have a table which nobody knows anything about except that it contains some important data which needs to be displayed in a report. The problem I have is that I dont quite know which field(s) are the key(s). Can anyone supply some sql which I can use to see if there are duplicates? I only have access to Informix from Microsoft SQL Server Management Studio Express Query using openquery statements. I have been told that maybe there are three fields within this table that make up the key but they are not sure. If I can execute some sql with these 3 fields to see if there are duplicates then maybe I can assume that these are the key fields. BTW I am a database developer but a C# developer who has been asked to solve this problem which has arisen. Thanks in advance.