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 INTEGER DEFAULT 1 ,rvw INTEGER DEFAULT 0 ,txt TEXT UNIQUE); sqlite> select txt, cnt, rvw from words where txt!="" and rvw!=0 order by cnt desc; talk |2|1 be |2|1 words|2|1 ready|2|1 to |1|1 need |1|1 The result I am trying to get is: be |2|1 ready|2|1 talk |2|1 words|2|1 need |1|1 to |1|1 T hanks, Jeff _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
