[sqlite] whish list for 2016
Hi all, What I meant to ask was: a) Either an ORDER BY clause/equivalent for group_concat() [not GROUP BY as originally posted], or an assurance that the kludge of sorting a sub-query first and then grouping the result does and will continue to work - I need this functionality. This is what happens when you post when tired! My thanks to Darren Duncan who questioned what I was asking for. Sorry I can't reply directly to Darren's message as I get the list via digest. I am using group_concat() to form lists of team members in a single report field, and wish to control the order of the items concatenated. The documentation explicitly states that "The order of the concatenated elements is arbitrary", but searching the internet finds a number of answers along the lines of: select a, group_concat(b) from (select a, b from db order by a, b desc) order by a; where the ordering of the sub-select "b desc" is preserved in the group_concat() result. This seems to work in practice, but I would really like to have surety on a way to achieve this other than doing it in my application; other SQL implementations have this feature. Thanks, Len Chisholm.
[sqlite] whish list for 2016
Joining the throng, here are my requests: a) Either an ORDER BY clause/equivalent for GROUP BY, or an assurance that the kludge of sorting a sub-query first and then grouping the result does and will continue to work - I need this functionality. b) A separate mailing address for documentation corrections - I see so many typos but it doesn't seem worth spamming the whole list to request an apostrophe be added or two letters be exchanged. c) A vote for RANK, but I'm doing that in my application at present, post-SQL but before printing. I know you can generate 1,2,3=,3=,5 type sequences from self-joins but it seems a lot easier to do it in Delphi! BTW I am having a great deal of enjoyment with SQLite in my application, which is a scoring database for card tournaments in New Zealand. I know it's small compared to some of the monsters I've seen described here, but I have 38 tables and 54 views in my schema, with 400-ish players and over 2800 score records in the national euchre tournament DB. Len Chisholm.