[AccessD] TOP n ordered book

Fri Jun 13 07:41:58 CDT 2003

Hi Ervin

Yes! Look up:

  "Selecting Nth Max or Min from a table"

in the archive at 2003-05-01.

/gustav

> I have a table with 2 columns:
>
> BookId      BookOrdered
> 1                    10
> 2                    25
> 1                     2
> 3                    50
> 1                      3
>
> and want to get the top e.g. 2 most popular books:
> BookId BookOrdered
>
> 3                    50
> 2                    25
>
> Are there any clue?