Home Forums SQL Server 7,2000 T-SQL Output results based on row comparison? RE: Output results based on row comparison?

  • June 24, 2004 at 2:58 pm

    #511876

    Hey Doug,

    Maybe breaking it out will make it easier to see...

    (select min(foperno) from #temp t where t.fjobno = t1.fjobno and t.foperno > t1.foperno)

    Steve