求助 sql 查询 行反转的问题
有一个结果集如下:
bm id
201623060000000344 S00000047381151
201623060000000344 S00000047381150
201623060000000345 S00000047381152
201623060000000345 S00000047381153
201623060000000346 S00000047381154
201623060000000346 S00000047381155
201623060000000347 S00000047381156
201623060000000347 S00000047381157
希望得到如下的结果 集
bm id1 id2
201623060000000344 S00000047381151 S00000047381150
201623060000000345 S00000047381152 S00000047381153
201623060000000346 S00000047381154 S00000047381155
201623060000000347 S00000047381156 S00000047381157
sql 应该怎么写呢