select so_nbr from (select so_nbr from so_acc_nbr where acc_number='6686088'order by STS_DATE desc) where rownum=1;
select so_nbr from 表名 where SYS_DATE=(select max(SYS_DATE) from 表名)
我试了一下语句: select so_nbr from (select so_nbr from so_acc_nbr where acc_number='6686088'order by STS_DATE desc) where rownum=1; 总是提示我“missing right parenthesis” 如果不用“order by STS_DATE desc”这个语句就可以查出结果。
(select so_nbr from so_acc_nbr where acc_number='6686088'order by STS_DATE desc)
where rownum=1;
select so_nbr from
(select so_nbr from so_acc_nbr where acc_number='6686088'order by STS_DATE desc)
where rownum=1;
总是提示我“missing right parenthesis”
如果不用“order by STS_DATE desc”这个语句就可以查出结果。