1 declare levelx varchar2(30);
2 begin
3 select min(line_level) into levelx from aaaa
where linecode='aaa'
group by linecode having count(*)>=1
4* end;
2 begin
3 select min(line_level) into levelx from aaaa
where linecode='aaa'
group by linecode having count(*)>=1
4* end;
having子句错误select min(line_level) into levelx from aaaa where linecode='aaa';有可能得到空数据,你判断一下不就行了
select min(line_level) into levelx from aaaa
where linecode='aaa'
group by linecode having count(*)>=1