Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

an exercise in 06-agg implies group_concat has an ordering feature #180

Open
DanielBaird opened this issue Jul 18, 2017 · 1 comment
Open

an exercise in 06-agg implies group_concat has an ordering feature #180

DanielBaird opened this issue Jul 18, 2017 · 1 comment
Labels

Comments

@DanielBaird
Copy link

@DanielBaird DanielBaird commented Jul 18, 2017

The last exercise in episode 06 Aggregation demonstrates a group_concat and asks if there's a way to order the concatenated items.

As far as I can tell SQLite doesn't have a way to order group_concat without doing a subquery, and the lesson doesn't teach subqueries. The MySQL version of group_concat does have an order by option; I suspect this exercise is left over from a MySQL version of the lesson.

The simplest resolution would be to remove the exercise, but ideally it can be re-written with a different challenge.

@kokbent
Copy link

@kokbent kokbent commented Aug 15, 2017

Agreed with this. Was searching high and low for solution for this only to find out that sqlite's group_concat doesn't do order by

@remram44 remram44 added the type:bug label Jun 11, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
3 participants