I usually get what I want in SQLite, but this time around, the language beats me.
Basically I have a table where the TYPE is repeated often, but where the ID is unique. I want to return unique TYPEs with their corresponding, random, ID.
Here's my (simplified) data :
ID TYPE
1 CHARACTER
2 CHARACTER
3 PLACE
4 CHARACTER
5 OBJECT
6 OBJECT
7 PLACE
8 CHARACTER
9 PLACE
10 PLACE
Question
PyX
Hey guys,
I usually get what I want in SQLite, but this time around, the language beats me.
Basically I have a table where the TYPE is repeated often, but where the ID is unique. I want to return unique TYPEs with their corresponding, random, ID.
Here's my (simplified) data :
For instance, this could be a perfect result :
Thanks a lot in advance
Link to comment
Share on other sites
7 answers to this question
Recommended Posts