在一条select语句查出多条纪录时,我只想取得第一条纪录,直接指定rownum=1而不是p.rownum=1
SELECT pay_channel_id
INTO n_pay_channel_id
FROM acct_pay_channel p
WHERE acct_nbr = n_acct_nbr
AND p.priority = (select min(q.priority) from acct_pay_channel q where q.acct_nbr = n_acct_nbr)
AND ROWNUM = 1;