Home Forums SQL Server 7,2000 T-SQL Having and Max of a column RE: Having and Max of a column

  • October 8, 2009 at 9:45 pm

    #1063844

    Hi,

    just try with

    select colA,colB,colC,max(ColF)

    from mytable

    group by colA,colB,colC