我有一个数据库表(tbl_employee)如下图所示:
[img]http://dl.iteye.com/upload/picture/pic/127721/8f7d25f3-74dd-3bc5-b93a-77e0a3cc7063.jpg[/img]
我想通过一个SQL查询出如下的效果:
[img]http://dl.iteye.com/upload/picture/pic/127723/69047bb4-7133-3ff8-9256-0a12b3a6e382.jpg[/img]
这个查询SQL怎么写?
[code="java"]
select UUID,NAME, WMSYS.WM_CONCAT(DEPT_NAME) t From tbl_employee GROUP BY UUID,NAME;
[/code]
好好,不错不错,学习了…………