View Single Post

   
  #4 (permalink)  
Old 02-29-2008, 07:28 AM
andy
 
Posts: n/a
Default Re: SQL query - highest rated or least voted items

There are several ways I can think of to do this but here's one.

Two queries.
One returns the top 40%, another less than 5 votes.
Union.

Wrap them with another query and use distinct to de-dupe.

Ordering them in any way could of course be tricky as you're comparing
apples n oranges.

Reply With Quote