Jobs
Author: Kevin Luckett Date Submitted: 8/9/2005 Category: Database Compatibility: VB 6 This code has been accessed 5540 times.
Email Yourself this snippet:
None
Code
select * from [Table Name] where [Column Name] in( select [Column Name] from [Table Name] group by [Column Name]having Count(*) > 1) Example: select * from tbl_lot where lotid in ( select lotid from tbl_lot group by lotid having Count(*) > 1)
