先建立一个函数
create or replace function fff(yourage integer) return varchar2 is
Result varchar2;
begin
for aa in (select * from 表 where age>yourname) loop
Result:=Result||','||name
end loop;
return(Result);
end fff;然后用 sql查询
select fff(25) from dual
create or replace function fff(yourage integer) return varchar2 is
Result varchar2;
begin
for aa in (select * from 表 where age>yourname) loop
Result:=Result||','||name
end loop;
return(Result);
end fff;然后用 sql查询
select fff(25) from dual
select name as name1,
lead(name,1,'')over(order by name) as name2 ,
lead(name,2,'')over(order by name) as name3 ,
lead(name,3,'') over (order by name) as name4
from table_name where age >25 )
where rownum =1
select name as name1,
lead(name,1,'')over(order by name) as name2 ,
lead(name,2,'')over(order by name) as name3 ,
lead(name,3,'') over (order by name) as name4
from table_name where age >25 )
where rownum =1
这个才对,
但是数据量不能太大,否则就只能写函数了吧