select i.*,rownum,
(select p.code,p.name_zh from z_person p where i.person_id=p.id) as pCode pName,
(select g.name from z_groups g where i.group_id=g.id) as gName
from z_interrogee i where i.is_delete=0 and rownum between 0 and 1
select i.*,rownum,
(select p.code from z_person p where i.person_id=p.id) as pCode,
(select p.name_zh from z_person p where i.person_id=p.id) as pNameZh,
(select g.name from z_groups g where i.group_id=g.id) as gName
from z_interrogee i where i.is_delete=0 and rownum between 0 and 1
第二条语句正常执行，但是肯定有优化问题。请问像第一条这种多列需要as的语句怎么写。
另外我还想了一种方法：
select i.*,rownum,p.code,p.nameZh,
(select g.name from z_group g where i.group_id=g.id) as gName
from z_interrogee i,z_person p where i.person_id=p.id
and i.is_delete=0
and rownum between 0 and 1
但是还想了解想第一条需要一次一个语句查多列然后as的语句怎么写？求大虾赐教！！
------解决方案--------------------
select i.*,rownum,
p.code as pCode,
p.name_zh as pNameZh,
(select g.name from z_groups g where i.group_id=g.id) as gName
from z_interrogee i,z_person p where i.is_delete=0 and rownum between 0 and 1 and i.person_id=p.id(+)