Hello, due to the wonderful help that I have recieved before, I dare to ask
"I have records in a database with Category and Subcategory fields. How
would I formulate the query to return distinct results and return for
whatever I need to do with them?"
There may be thousands of category and subcategory duplications as they are
not the primary record identifier.
I.e. A record has a category of "Manuals" and a subcategory "Audio"
Another record has a category of "Manuals" and a subcategory "Phone"
A record has a category of "Receipts" and a subcategory "Water"
A record has a category of "Receipts" and a subcategory "Gas"
A record has a category of "Receipts" and a subcategory "Electricityr"
So they would look like:
Manuals
+ Audio
+ Phone
Receipts
+ Water
+ Gas
+ Electricity
The below doesn't work as I am unfamiliar with these sorts of queries.
"SELECT DISTINCT category from documents [SELECT DISTINCT IN subcategory
FROM documents]"
--
View this message in context:
http://www.nabble.com/Extracting-distinct-category-and-subcategory-pairs-tp17734716p17734716.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
