Re: [sqlite] How to get these ordered correctly

2016-10-26 Thread Igor Tandetnik
On 10/26/2016 10:53 AM, Jeff Archer wrote: Hi and thanks in advance for your help. I have a table of words and counts and I am trying to make a query which sorts in descending order of count but with each group of words that have the same count sorted alphabetically. MY table: CREATE TABLE

Re: [sqlite] How to get these ordered correctly

2016-10-26 Thread R Smith
On 2016/10/26 4:53 PM, Jeff Archer wrote: Hi and thanks in advance for your help. I have a table of words and counts and I am trying to make a query which sorts in descending order of count but with each group of words that have the same count sorted alphabetically. MY table: CREATE TABLE

[sqlite] How to get these ordered correctly

2016-10-26 Thread Jeff Archer
Hi and thanks in advance for your help. I have a table of words and counts and I am trying to make a query which sorts in descending order of count but with each group of words that have the same count sorted alphabetically. MY table: CREATE TABLE words (id INTEGER PRIMARY KEY AUTOINCREMENT ,cnt