GROUP BY clause to get comma-separated values in sqlite

Question

My table structure is like this, using sqlite3

           CREATE TABLE enghindi (eng TEXT,hindi TEXT)

i have an table named enghindi in that there is two column named hindi, eng, i want to merge eng column's record and also combine hindi word by comma separated

look at the below table is looking like

enter image description here

i want to do look like this below

enter image description here

i want to do this with sqlite3 query

score 18 · Accepted Answer · answered Oct 12 '13 at 09:42

18

This should work:

SELECT GROUP_CONCAT(eng), hindi FROM enghindi GROUP BY hindi;

answered Oct 12 '13 at 09:42

Sajuna Fernando

1,364
9
16

Thank you sooooooo much Sajuna Fermando :) you have saved my so much time – Siddhpura Amit Oct 12 '13 at 09:43
ya sure dost it says me you can accept answer after 15 min :( – Siddhpura Amit Oct 12 '13 at 09:45
Thats fine mate. No worries. – Sajuna Fernando Oct 12 '13 at 09:48
Hi Sajuna Fernando can you upvote my question and if you are free than pls try to solve my next query http://stackoverflow.com/questions/19356996/join-on-two-different-tables-column-sqlite3 – Siddhpura Amit Oct 14 '13 at 09:18

GROUP BY clause to get comma-separated values in sqlite

1 Answers1

Linked