drop table STAFF;
create table STAFF
(
id varchar2(8),
name VARCHAR2(8),
sex VARCHAR2(8),
status VARCHAR2(8)
);
insert into STAFF (id,name,sex,status) values ('1', '张三','男','1');
insert into STAFF (id,name,sex,status) values ('2', '李四','男','0');
insert into STAFF (id,name,sex,status) values ('3', '王晓燕','女','1');
insert into STAFF (id,name,sex,status) values ('4', '赵兰兰','女','0');
commit;
select wmsys.wm_concat(name)
from staff
group by status
having status=0 |