1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| /*attention l'ordre est important*/
select *,
case
when DATEDIFF( NOW( ) ,`Deadline`) > 0 then 'obsolete'
when DATEDIFF( NOW( ) ,`Saisie` ) > 15 then 'last'
when DATEDIFF( NOW( ) ,`DatRel` ) < 15 then 'datrelnew'
when DATEDIFF( NOW( ) ,`DatRel2` ) < 15 then 'datrelnew2'
when DATEDIFF( NOW( ) ,`DatTrans` ) < 15 then 'dattransnew'
when DATEDIFF( NOW( ) ,`Date` ) > 120 then 'megaold'
when DATEDIFF( NOW( ) ,`Date` ) > 90 then 'old'
when DATEDIFF( NOW( ) ,`Date` ) > 60 then 'med'
when DATEDIFF( NOW( ) ,`Date` ) > 30 then 'hava'
when DATEDIFF( NOW( ) ,`Date` ) > 15 then 'new'
end as anciennete
FROM ta_table
WHERE `Actif` <> 'Non'
ORDER BY field(anciennete,'last','new','hava','med','old','megaold','dattransnew','datrelnew','datrelnew2','obsolete'); |
Partager