Selecting the nth row with a GROUP BY

[mellenburg]

I have a table that has 5 groups. From each group (of varying number of rows), I would like to select the 10th row. Can this be done in a query?

If not, or in addition, is there a way to add a column to a table that would be the row number of each group. For instance.

Group NEWCOLUMN
A 1
A 2
A 3
B 1
B 2
B 3
B 4
B 5

etc...

 

[swampBoogie]

>> I have a table that has 5 groups. From each group (of varying number of rows), I would like to select the 10th row. Can this be done in a query? >>

Not with Mysql. You have to do that in your application.

The same holds for the second question.