CODEWITHSUNDEEP
mysqlsqlsqliteandroid-sqlite
Siddhpura Amit
Siddhpura Amit

Reputation: 15078

GROUP BY clause to get comma-separated values in sqlite

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

Upvotes: 12

Views: 7097

Answers (1)

Sajuna Fernando
Sajuna Fernando

Reputation: 1384

This should work:

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

Upvotes: 18

Related Questions