MySQL Forums
Forum List  »  Newbie

Re: error code 1241, operand should contain 1 column(s)
Posted by: M IC
Date: January 14, 2013 05:26AM

HI Laptop alias and Peter Brawley,

Thank you both for the suggestions. I need to find each horse that has been placed in the top 3, two or more times. From Peter's suggestion, the result I got is only 1 horse, and from Laptop's suggestion, the result I got is 4 horses. Below is the table.

Event_id Horse_id Place
101 101 1
101 102 2
101 201 3
101 301 4
102 201 2
103 201 3
201 101 1
301 301 2
401 102 7

Options: ReplyQuote


Subject
Written By
Posted
Re: error code 1241, operand should contain 1 column(s)
January 14, 2013 05:26AM


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.