select
  LESSER(LESSER(LESSER(LESSER(p1, p2), p3), p4), p5) as MIN_FROM_COLUMN,
  GREATER(GREATER(GREATER(GREATER(p1, p2), p3), p4), p5) as MAX_FROM_COLUMN
from
(
  select  0  as ORD,  1  as p1,  0  as p2,  0  as p3,  0  as p4, - 2  as p5 from SYS.DUMMY
  union
  select  1  as ORD,  0  as p1,  2  as p2,  0  as p3, - 1  as p4,  0  as p5 from SYS.DUMMY
  union
  select  2  as ORD,  0  as p1,  0  as p2,  3  as p3,  0  as p4,  0  as p5 from SYS.DUMMY
  union
  select  3  as ORD,  0  as p1,  0  as p2, - 1  as p3,  4  as p4,  0  as p5 from SYS.DUMMY
  union
  select  4  as ORD,  0  as p1, - 2  as p2,  0  as p3,  0  as p4,  5  as p5 from SYS.DUMMY
) as #TMP
order by
  #TMP.ORD asc