I have one table like this:
info is like:
1, "news title 1" , "reuters"
2, "news title 2" , "afp"
there are approx. 10,000 records from which the first 5000 come from "reuters" and the rest come from "afp". I want to create a news listing page, so I have to mingle both news types. Union and Union All does not work because it keeps
the reuters-related records on top of AFP related while I need a list of 20 news containing both Reuters and AFP.
what is the best solution (including performance concerns) to do this?
View Complete Post