select  (
select CATEG from
(select CATEG  from SHIFTS where TABNOM = STATE.TABNOM  order by TABNOM, DATEPR desc)
where ROWNUM = 1
)
from STATE

select (select max(categ) keep (dense_rank first order by datepr desc) categ
          from shifts
         where tabnom = state.tabnom)
  from state

select (
    select distinct First_Value(h.Categ) over (partition by h.Tabnom order by h.Datepr desc)
    from SHIFTS h
    where h.TabNom = s.Tabnom)
from State s

select
   (select SHIFTS.CATEG
       from SHIFTS where SHIFTS.TABNOM = STATE.TABNOM
       order by SHIFTS.DATEPR desc
       LIMIT 1
   ) as CATEG
 from STATE

select
  ( select TAB1.CATEG as CAT1 from
    ( select SHIFTS.CATEG as CAT2 from SHIFTS
       where SHIFTS.TABNOM = STATE.TABNOM
       order by SHIFTS.DATEPR desc) as TAB1
      where ROWNUM = 1
   ) as CATEG
from STATE