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 Quote Link to comment 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. Quote Link to comment 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 Quote Link to comment 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 Quote Link to comment 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! Quote Link to comment 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 :/ Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.