What is wrong in this SQL code?

[Miguel Dias Moura]

Hello,

i have this code to order the 3 authors that appear more often in a book
database:

SELECT Author, COUNT(Author) AS totalBooks
FROM Books
GROUP BY Author
ORDER BY totalBooks DESC

When i added the line "ORDER BY totalBooks DESC" i got the error:
System.Data.OleDb.OleDbException: No value given for one or more required
parameters.

Without this line it works ok but it's not sorted as i want.

Can you tell me what is going on?

Thank You,
Miguel

 

[Kevin Spencer]

Try

ORDER BY COUNT(Author)

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 

[Carlos Barini]

Try this

SELECT Author, COUNT(Author) AS totalBooks
FROM Books
GROUP BY Author
ORDER BY COUNT(Author) DESC

Carlos Barini
MCP, MCSA, MCSE, MCDBA

 

[Miguel Dias Moura]

Thanks,

i just made it work.

Cheers,
Miguel

Try this

SELECT Author, COUNT(Author) AS totalBooks
FROM Books
GROUP BY Author
ORDER BY COUNT(Author) DESC

Carlos Barini
MCP, MCSA, MCSE, MCDBA