mardi 6 octobre 2015

Compare rows with a column value

I'm trying to figure out how to retrieve all rows with a ID which have a specific value in the other column.

The database looks like this:

Database Illustration

I want to retrieve those rows which have a VAL of 2 and the corresponding ID rows. So in this case this would give me all the ID 1 rows and the ID 3 row:

Database Illustration 2

Aucun commentaire:

Enregistrer un commentaire