GROUP BY should display 3 records from each group.. how..?
when i give group by to a field you will get one records for each value.
that means if you have 500 articles and that is associated with 5 countries and if u give GROUP BY country_id i will get total 5 records,one for each country_id.here i want a solution using a single query to get 3 records from each country.
that means instead of 5 results i may require 15 or 25..?how
i have posted same thread in some other forum and you can check the status of that using the following URL
Other Thread Link
