SQL Dual Sort?

[mrbee2828]

I'm trying to sort records twice based on a vote average and second on the number of votes. I'd like to have a top 5 vote display. The issue is that I don't want an item that has 100 votes and an average of 4.9 to be second to an item that has 1 vote and an average of 5.0. Is this possible?

[digitalpoint]

You probably are going to define some sort of weighting system for your sort since a straight sort wouldn't work.

[mrbee2828]

Great.. does anyone have any idea how to do this? Is it done in the SQL statement or the DB?

[vrsane]

what database you are using ....?

[T0PS3O]

Easiest would be to include a treshold for the number of votes. If it's below 10 then don't use it. From there on the average becomes normalized and trustworthy. The actual figure depends on the average number of votes you get I guess.

[mrbee2828]

Thanks TOPS30, I think that's a pretty decent solution.. seems to work.

[rembrandt]

sort records using a union clause and order by your required fields