if exists(select end_date from (select * from record order by rownum desc) where rownum=1 and end_date<your_input_start_date)
select id,name,start_date,end_date,lag(end_date,1) over ( order by end_date) last_end_date from temp
在pl/sql中报这样的错,record实际是从一个表中抓到的数据,我添加了上边的语句后, 显示Encountered symbol "ORDER"when expecting one of the following:.),@ with<an identifier> <a double-quoted delimited-identifier>group having intersect minus partition start union where connect
from temp
显示Encountered symbol "ORDER"when expecting one of the following:.),@ with<an identifier>
<a double-quoted delimited-identifier>group having intersect minus partition start union where connect