sql exercises idea: take a table and some queries and write down the results by handpic.twitter.com/2Fr0YwhsQc
Show this thread
-
which part is mysql specific?
`GROUP_CONCAT` is for sure. COUNT(DISTINCT) isn't MySQL specific, but also isn't supported by all SQL DBs.
-
-
yeah, maybe GROUP_CONCAT isn't the most exciting thing to put in an exercise anyway also
-
It's probably a self-explanatory enough function that it doesn't matter. At the end of the day each backend implements its own partially overlapping subset of the SQL standard plus non-standard extensions, so it's hard to write any truly DB independent examples
- 1 more reply
New conversation -
-
-
It seems SQLite has a `GROUP_CONCAT` function as well, but it has different semantics than MySQL... (`CONCAT` also has different semantics across the open source SQL backends. Writing ORMs is fun \o/)
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.