2013年9月5日星期四

android SQLITE how to implement data consolidation

There is a list:
DepID StaffName
----------------------
101 AAAaa
101 BBBb
101 CCCccc
202 DDDddd
202 EEE
202 FFF
303 GGGGG

table illustrates , DepID for the department ID, StaffName as employee name , a department of course there will 0 .. N multiple employees :)

how to use SQL statements following the above table are combined into a way of doing things .
DepID StaffNames
-------------------
101 AAAaa; BBBb; CCCccc
202 DDDddd; EEE; FFF
303 GGGGG
------ Solution --------------------------------- -----------
this line can not be, nor is it in oracle able to get 3,2 sentence .
If the amount of data or programs merge it.
------ For reference only -------------------------------------- -
has been resolved , SQLITE group_contact provides a function to implement this feature

没有评论:

发表评论