SQL query to select distinct record with 2 or more repetition in another field
Posted
by kyohiros
on Stack Overflow
See other posts from Stack Overflow
or by kyohiros
Published on 2010-05-15T14:54:02Z
Indexed on
2010/05/15
15:24 UTC
Read the original article
Hit count: 215
sql
So I have this table of book orders, it contains 2 columns, one is the order ID(primary key) and another is the ID of the book that the customer ordered. For example:
| OrderID | BookID |
| 0001 | B002 |
| 0002 | B005 |
| 0003 | B002 |
| 0004 | B003 |
| 0005 | B005 |
| 0006 | B002 |
| 0007 | B002 |
What I want is to get the IDs of the books that got 2 or more purchases/orders, for example if I run the SQL query against the above data, I would get this as the result:
| BookID |
| B002 |
| B005 |
I don't know if this can be archived in SQL or I have to built a simpler statement and repetitive run the query against all the records in another language. I need some help and thanks for reading my question.
© Stack Overflow or respective owner