How to display 3 records of a database?

[Steven Spits]

Hi,

Basicly i want to display the names of the authors that published more
books.

This is the SQL statement you need:

SELECT TOP 3 Author, COUNT(Author) AS Total
FROM Books
GROUP BY Author
ORDER BY Total DESC

With kind regards,

Steven Spits

- - -

 

[Miguel Dias Moura]

Hello,

I am working in and ASP.net / VB web site with Access database. I have a
database of books with the following fields:

PrimaryKey; Book Title; Author

I want to display in a web page the names of the 3 Authors which appear more
often in the database.
Basicly i want to display the names of the authors that published more
books.

John Smith - 21 Books Published
Mary Dias - 15 Books Published
Jack Slater - 12 Books Published

Can you help me out?

Thank You Very Much,
Miguel