MySQL Forums
Forum List  »  MySQL Query Browser

Compare with previous tuple(Row)
Posted by: M Zubair Haroon
Date: September 20, 2012 02:30PM

Hi! I 'm stuck on a very basic problem, I want to skip the row which has duplicate values over three columns.

Table feeds

id,type,user_id,friend_id,date

1, 'friend', 4 , 5 , 5/5/2010
2, 'friend', 5 , 4 , 5/5/2010

Now since both have same thing, so I want to pick them only as a 1 row not 2.

Now this is how the data is saved (I can't change the saving module)

Need help, thanks

Options: ReplyQuote


Subject
Written By
Posted
Compare with previous tuple(Row)
September 20, 2012 02:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.