[dba-SQLServer] Top two of each group

I believe that might be able to be defined in your output in MaxRows or
TopValues.

HTH,

Donna

Quoting Francisco H Tapia <my.lists at verizon.net>:

> I have a little select statement, which gives me a grouping of
>
> Model1 Frame and Week1
> Model1 Frame and week2
> Model1 Frame and Week3
> Model2 Frame and Week1
> Model2 Frame and week2
> Model2 Frame and Week3
> Model2 Frame and Week3
> Model3 Frame and week2
> Model3 Frame and Week3
> ... etc
>
> I'm blanking out on collecting the TOP 2 of each model, instead of
> seeing the entire model list, How would one just collect the TOP two of
> each model type?
>
> I can think of how to do this in a cursor, but I'd like to avoid that if
> at all possible.
>
> --
> -Francisco
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>