zohab Posted February 3, 2009 Share Posted February 3, 2009 hi all, I want to select identical records from table table id firstname lastname email 1 first last email 2 xyz pqr sss 3 first last email 4 mmm lll rrr 5 first last email in above table records 1,3 and 5 are identical I want to know select query to get record 1,3 and 5 Quote Link to comment https://forums.phpfreaks.com/topic/143592-select-identical-records-from-table/ Share on other sites More sharing options...
peddel Posted February 3, 2009 Share Posted February 3, 2009 if u know the value of the identical record u can do this SELECT * FROM table WHERE table.firstname = 'first' Quote Link to comment https://forums.phpfreaks.com/topic/143592-select-identical-records-from-table/#findComment-753439 Share on other sites More sharing options...
zohab Posted February 3, 2009 Author Share Posted February 3, 2009 Hi peddel, I do not know the value of identical record Quote Link to comment https://forums.phpfreaks.com/topic/143592-select-identical-records-from-table/#findComment-753449 Share on other sites More sharing options...
peddel Posted February 3, 2009 Share Posted February 3, 2009 Could u tell me why u need to know the doubles? Cuz im guessing there is more to this. Try to explain me the situation it is in Quote Link to comment https://forums.phpfreaks.com/topic/143592-select-identical-records-from-table/#findComment-753542 Share on other sites More sharing options...
revraz Posted February 3, 2009 Share Posted February 3, 2009 You can probably do a self join, see if this helps http://www.phpfreaks.com/forums/index.php/topic,233331.0.html Quote Link to comment https://forums.phpfreaks.com/topic/143592-select-identical-records-from-table/#findComment-753553 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.