Calculating the most occuring record in a table.

roadrage

Registered User.
Local time
Today, 16:17
Joined
Dec 10, 2007
Messages
62
I have a Database that contains a number Albums and Artists. I also have a table that contains orders from customers for these albms. Basically i want to track which album and artist is bought most? Can any one help?
 
Its ok please ignore as i have solved this by doing a group by count.!:)
 

Users who are viewing this thread

Back
Top Bottom