Sqlite group_concat ordering

by

Can you not use a subselect with the order by clause in, and then group concat the values?

Something like

SELECT ID, GROUP_CONCAT(Val)
FROM (
   SELECT ID, Val
   FROM YourTable
   ORDER BY ID, Val
   )
GROUP BY ID;

More Related Contents:

  1. How do I unlock a SQLite database?
  2. “Insert if not exists” statement in SQLite
  3. How to delete or add column in SQLITE?
  4. Android – Pulling SQlite database android device
  5. How to get Top 5 records in SqLite?
  6. Insert new column into table in sqlite?
  7. How do you enable LIMIT for DELETE in SQLite?
  8. SQLite Schema Information Metadata
  9. How to create custom functions in SQLite
  10. is there a limit to the size of a SQLite database?
  11. How to generate all dates between two dates
  12. Does it matter what extension is used for SQLite database files?
  13. How do I DROP a constraint from a sqlite (3.6.21) table?
  14. How do I add a new column in between two columns?
  15. Creating stored procedure and SQLite?
  16. How Scalable is SQLite? [closed]
  17. change sqlite file size after “DELETE FROM table”
  18. Are there any reserved words in SQLite?
  19. What is the difference between related SQLite data-types like INT, INTEGER, SMALLINT and TINYINT?
  20. Modify a Column’s Type in sqlite3
  21. Case sensitive and insensitive like in SQLite
  22. SQLite accent-insensitive search
  23. How to have an automatic timestamp in SQLite?
  24. svn cleanup: sqlite: database disk image is malformed
  25. SELECT INTO statement in sqlite
  26. How to display blob value using x’abc’ binary string literal syntax?
  27. Unable to load DLL sqlite3 in Universal Windows App running on Mobile
  28. DbFunctions.TruncateTime LINQ equivalent in EF CORE
  29. How to get the number of rows of the selected result from sqlite3?
  30. How to get the last index of a substring in SQLite?

Leave a Comment