If Else clause or decode or Case in Where clause

 If Else clause or decode or case in Where clause

We are not going to check here if else or decode or case but i am going to tell u an alternate.........

Suppose we need workorder's with status =APPR  else I need WAPPR but i have to give preference to APPR solution

select * from maximo.workorder where status in (APPR,WAPPR) order by status desc

Now suppose we have 2 records one is appr and one is wappr

Then modify this query like 

Select * from maximo.workorder where workorderid in (

select workorderid  from maximo.wokrorder where workorderid in (select workorderid from maximo.workorder where status in (APPR,WAPPR) order by status desc

)  where rownum<2)

So we are using here rownum to display approve before wappr ............

If we have only wappr records then our subquery will return wappr records only and with  rownum<2 

we will get only one record....................

This you can use in relationship of maximo where u have to find 1 record only as fetch 1st alternate.......