Re: finding duplicate fields in a table

Select cane, box, row, freezercolumn from freezer group by 1, 2, 3, 4 having count(*) > 1 ??? Brian Grellinger I.S. Manager Doosan Infracore America Corp Information Systems >>> "Water" <taurora@gmail.com> 02/06/06 12:11PM >>> Hi Group, I am having problem finding duplicate fields in a table. I have tried some of the suggestions which were posted for a similar question but didn't get the desired output. so I have a table say freezer and it has column names - cane, box, row, freezercolumn and more. There are records which have same values for cane,box,row and freezercolumn only and I want to list them out. Could you guys help me out. Thanks in advance. Water _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list