I am not the greatest at SQL and I am trying to achieve the following:

I have a table with columns like so:

```
id | cup_type | cup_id | name

```

I have a ton of records in the database which will have the same `cup_id` but different `cup_types`

I would really like to select records that have the same `cup_id` but different `cup_types`

```
id | cup_type | cup_id | name
1  | TypeOne  | 12     | NameOne
2  | TypeTwo  | 12     | NameTwo
3  | TypeOne  | 13     | NameThree
4  | TypeTwo  | 13     | NameFour
5  | TypeOne  | 14     | NameFive
6  | TypeOne  | 14     | NameSix

```

When I run the said query it would being me back the following:

```
id | cup_type | cup_id | name
1  | TypeOne  | 12     | NameOne
2  | TypeTwo  | 12     | NameTwo
3  | TypeOne  | 13     | NameThree
4  | TypeTwo  | 13     | NameFour

```

I hope I have explained this ok and let me know if more clarity is needed.