willpower Posted October 1, 2007 Share Posted October 1, 2007 Hi id | memberNo | memberNo2 1 | 1 | 2 2 | 1 | 3 3 | 2 | 4 How do I select NON DISTINCT values in memberNo History - I am merging several user DB's into one and this is simply a validation process to detect dupliactes Thanks Will Link to comment https://forums.phpfreaks.com/topic/71447-non-distinct-rows/ Share on other sites More sharing options...
marcus Posted October 1, 2007 Share Posted October 1, 2007 You're basically asking how to select all the rows. Link to comment https://forums.phpfreaks.com/topic/71447-non-distinct-rows/#findComment-359661 Share on other sites More sharing options...
willpower Posted October 1, 2007 Author Share Posted October 1, 2007 no as id 3 IS distinct...i dont want it returned....try again Link to comment https://forums.phpfreaks.com/topic/71447-non-distinct-rows/#findComment-359667 Share on other sites More sharing options...
BlueSkyIS Posted October 1, 2007 Share Posted October 1, 2007 non-distinct i assume is another term for duplicate? SELECT id, memberNo, count( * ) AS n FROM table GROUP BY memberNo HAVING n >1 Link to comment https://forums.phpfreaks.com/topic/71447-non-distinct-rows/#findComment-359669 Share on other sites More sharing options...
willpower Posted October 1, 2007 Author Share Posted October 1, 2007 Thanks Seems mr 15 years old with all his working websites needs to learn to read! Link to comment https://forums.phpfreaks.com/topic/71447-non-distinct-rows/#findComment-359675 Share on other sites More sharing options...
marcus Posted October 1, 2007 Share Posted October 1, 2007 Is the nagging necessary? Cocky people these days :/ Link to comment https://forums.phpfreaks.com/topic/71447-non-distinct-rows/#findComment-359676 Share on other sites More sharing options...
willpower Posted October 2, 2007 Author Share Posted October 2, 2007 I rather think that it was you how was cocky...hence my retort. Had you read my post perhaps you may not have been so flippant in your response. I thank you for taking the time to open my post, id thank you even more if you read it. Will Link to comment https://forums.phpfreaks.com/topic/71447-non-distinct-rows/#findComment-359710 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.