获得最近打开的期间

select max(period_name)
from gl_period_statuses gps
where substr(gps.period_name,4,4)=
(select max(substr(gps.period_name,4,4))
   from gl_period_statuses  gps
  where  gps.period_type= ( select distinct period_type
                              from  gl_periods
                             where  period_set_name='总帐期间')
                               and (gps.closing_status ='C' or gps.closing_status='O'))
and gps.period_type= ( select distinct period_type
                              from  gl_periods
                             where  period_set_name='总帐期间')
and (gps.closing_status ='C' or gps.closing_status='O')

 

在期间的打开关闭窗口有一个：最后打开的期间。但是不知道这个是怎么取到的。或者数据库中有专门这样的API.-------暂记这里，回头查查