Home Forums SQL Server 2005 T-SQL (SS2K5) Minimum Value 3 Fields > 0 RE: Minimum Value 3 Fields > 0

  • September 13, 2012 at 6:33 am

    #1537161

    Try This

    🙂

    select Id,MIN(a) from (

    select a.id, a.a from #MinAmt a ,#MinAmt

    union

    select a.id, a.b from #MinAmt a ,#MinAmt

    union

    select a.id, a.c from #MinAmt a ,#MinAmt

    ) a where a>0 group by Id