Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: top n percent WITH group by?

    I've had to do something like this before.  Using the derived table concept should simplify your life. 

    select top 90 percent

     from

     (select fld1,fld2 from MyTestTable group by fld1,fld2)

    In this...

Viewing post 1 (of 1 total)