Retrieve 10 records with GROUP parameter

[luciai]

Can someone help me with this one? I want to display the last 10 records max. within each sub-category. My code seems not to be correct because I get all the records for each sub-category. Any help would be appreciated. Thanks.

The following is my output code:
<CFOUTPUT QUERY=&quot;get_travel&quot; MAXROWS=&quot;10&quot; GROUP=&quot;SubCatID&quot; >
<UL type=&quot;disc&quot;>
<b>#SubCategory#</b>
<CFOUTPUT>
<LI><a href=&quot;View.cfm?MainCatID=2&NewsID=#NewsID#&quot;>#title#</a>
</LI>
</CFOUTPUT>
</ul>

<div align=right> <a href=&quot;travelerView.cfm?SubCatID=#SubCatID#&quot;><font size=&quot;1&quot;>More #subCategory# >></font></a></div>
</CFOUTPUT>