请教，大家帮忙看看这个SQL怎样写

rollingpig

是不好写……

可以考虑写一个funtion

比如
create or replace function all_note(p_gradeid in number , p_Classid in number)
as
v_all_notes varchar2(1000);
begin
for i in (select note from t_name where gradeid  = p_gradeid
and Classid = p_Classid  ) loop
v_all_notes := v_all_notes ||'/' ;
end loop;
return v_all_notes ;
end;

rollingpig

create or replace function all_note(p_gradeid in number , p_Classid in number)
as
v_all_notes varchar2(1000);
begin
for i in (select note from t_name where gradeid  = p_gradeid
and Classid = p_Classid  ) loop
if(v_all_notes is null ) then
v_all_notes := i.note ;
else
v_all_notes :=  v_all_notes||'/' ||i.note  ;
end if;
end loop;
return v_all_notes ;
end;

blue_stone

我写了一个聚合函数, 可以把字符串连接起来
http://bbs.chinaunix.net/viewthr ... &extra=page%3D1