uHtmY6LC

1CREATE TABLE IF NOT EXISTS `User` (
2  `id` bigint(20) NOT NULL,
3  `address1` text COLLATE utf8_unicode_ci,
4  `mobile` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
5  `name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
6  `firstName` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
7  `lastName` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
8  `username` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
9  `password` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
10  `email` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
11  `gender` tinyint(2) NOT NULL DEFAULT '0' COMMENT '1 - female, 2-male, 0 - unknown',
12  `zip` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
13  `countryCode` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
14  `joinedDate` datetime DEFAULT NULL,
15  `dateOfBirth` date DEFAULT NULL COMMENT 'User date of birth'
16) ENGINE=MyISAM AUTO_INCREMENT=63561 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
17	
18SELECT id, firstName, lastName, mobile, email, count(*) as dupCount FROM `User` `t` WHERE firstName is not null and lastName is not null GROUP BY firstName,lastName HAVING count(*) > 1