Dennis Cote wrote: > > flakpit wrote: > > You could try > > select distinct category, subcategory > from documents > order by category, subcategory; > > Then your application can do the display formatting, such as suppressing > the display of the category when it is the same as the last record. >
You might be right at that. I'll have a try. Thank you for the suggestion. -- View this message in context: http://www.nabble.com/Extracting-distinct-category-and-subcategory-pairs-tp17734716p17735884.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