Get all row in one in sqlite

I have a table in sqlite android which contain some data.
like this

Table id
        1
        2  
        3
        4
        5
        6
        7

what i want is String which contain all ids with ";" separator like

 1;2;3;4;5;6;7

i know there is group concat .but i cannot figures out how to do that whit this sample.

and there is another methode called COALESCE i funded from here but in sqlite we cannot declare variable.

so is there any way to do this in sqlite?