lundi 4 avril 2016

Get data from string of specific values SQL

I'm rather new at SQL programming, and still struggling with the basics. I need to extract some specific rows, from a specified string of IDs.

ID  Product City
1   Apple   London
2   Banana  Berlin
3   Orange  Berlin
4   Orange  Paris
5   Apple   Paris
6   Banana  Copenhagen
7   Banana  Copenhagen
8   Banana  London
9   Apple   Paris
10  Orange  London
11  Apple   Berlin
12  Apple   Copenhagen
13  Apple   Paris

If I need to select ID=1,2,5,6,10,11,13 how do I extract these specific rows from the database? I'm using SQLite.

Thanks in advance.

Aucun commentaire:

Enregistrer un commentaire