How to get various records in the result set

2009-07-07 Thread fei dong
Hi buddy, I am working on a music search project and I have a special requirement about the ranking when querying the artist name. Ex: When I query the artist ne yo, there are 500results and maybe 100 song names are repeated. So the ideal thing is to let users get more different songs in on page

Re: How to get various records in the result set

2009-07-07 Thread Chris Hostetter
duplicate post? http://www.nabble.com/how-to-shuffle-the-result-while-follow-some-priority-rules-at-the--same-time-to24282025.html#a24282025 FYI: reposting the same question twice doesn't tend to get responses faster, it just increases the total volume of mail and slows down everyones ability