Re: [sqlite] Extracting distinct category and subcategory pairs

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

Re: [sqlite] Extracting distinct category and subcategory pairs

flakpit wrote: > > 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

Re: [sqlite] Extracting distinct category and subcategory pairs

Hi Gary, Does SELECT DISTINCT category, subcategory from documents; not provide what you want? If not you may need to be more specific. Rgds, Simon ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Extracting distinct category and subcategory pairs

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