[AccessD] TOP n ordered book

Try this:

Select TOP 2 from tblBooks Order By BookOrdered DESC

Jeanine
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Ervin Brindza
Sent: Friday, June 13, 2003 7:29 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] TOP n ordered book

Hi,
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?
TIA,
    Ervin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030613/99100f39/attachment-0001.html>