roadrage
03-10-2008, 02:51 AM
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?
|
View Full Version : Calculating the most occuring record in a table. roadrage 03-10-2008, 02:51 AM 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? roadrage 03-10-2008, 02:56 AM Its ok please ignore as i have solved this by doing a group by count.!:) |