By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
name | counter | group_concat(concat_ws(',', empid, name, gender) separator '),(') |
---|---|---|
Andrew | 1 | 5,Andrew,M |
Moeen | 2 | 7,Moeen,F),(11,Moeen,M |
Suresh Raina | 1 | 1,Suresh Raina,M |
name | count | flds |
---|---|---|
Andrew | 1 | |
Moeen | 2 | (7,Moeen,F),(11,Moeen,M) |
Suresh Raina | 1 |