我在数据里面添加了rownum=1仍然出现单行子查询返回多个行？

Question

SELECT distinct ID_NO,SHOULD_PAY,FAVOUR_FEE,(SELECT nvl(SHOULD_PAY,0)-nvl(FAVOUR_FEE,0) AS fee1 FROM ODS_ACT_PAYEDOWE) from ODS_ACT_PAYEDOWE WHERE RECORD_TIME=(select max(RECORD_TIME) FROM ODS_ACT_PAYEDOWE) and rownum=1

Answer 1

select a.directflag,(select sheettypename fromsheettype where id=(select sheettypeid from moduletype where moduleid=trim(a.sheetidruleid)))其中,(select sheettypename fromsheettype where id=(select sheettypeid from moduletype where moduleid=trim(a.sheetidruleid部分也必须返回一个值，否则没有办法和a.directflag构成一个元组！