Getting top 2 by Category

<div class="WordSection1"><p class="MsoNormal">This is probably very simple but I am drawing a blank.  Do I need to
createa cursor to iterate through a table to grab the top 2 magazines per category?  Here is my table and some data . 
Theresults I need are at the  bottom.  Any help would be greatly appreciated:<p class="MsoNormal"> <p
class="MsoNormal">CREATETABLE magazinecategory<p class="MsoNormal">(<p class="MsoNormal">  magazinecategoryid smallint
NOTNULL ,<p class="MsoNormal">  magazineid smallint,<p class="MsoNormal">  categoryid smallint<p class="MsoNormal">);<p
class="MsoNormal"> <pclass="MsoNormal">INSERT INTO magazinecategory(<p class="MsoNormal">           
magazinecategoryid,magazineid, categoryid)<p class="MsoNormal">    VALUES (1, 2, 3);<p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal">INSERT INTO magazinecategory(<p class="MsoNormal">           
magazinecategoryid,magazineid, categoryid)<p class="MsoNormal">    VALUES (2, 8, 3);<p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal">INSERT INTO magazinecategory(<p class="MsoNormal">           
magazinecategoryid,magazineid, categoryid)<p class="MsoNormal">    VALUES (3 9, 3);<p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal">INSERT INTO magazinecategory(<p class="MsoNormal">           
magazinecategoryid,magazineid, categoryid)<p class="MsoNormal">    VALUES (4, 10, 4);<p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal"> <p class="MsoNormal">INSERT INTO magazinecategory(<p
class="MsoNormal">           magazinecategoryid, magazineid, categoryid)<p class="MsoNormal">    VALUES (5, 11, 4);<p
class="MsoNormal"> <pclass="MsoNormal">INSERT INTO magazinecategory(<p class="MsoNormal">           
magazinecategoryid,magazineid, categoryid)<p class="MsoNormal">    VALUES (6, 12,4);<p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal"> <p class="MsoNormal">The results I want are<p class="MsoNormal">CategoryID 
MagazineID<pclass="MsoNormal">3 2<p class="MsoNormal">3 8<p class="MsoNormal">4 10<p class="MsoNormal">4 11<p
class="MsoNormal"> <pclass="MsoNormal"> <p class="MsoNormal"> <div id="content"><p class="MsoNormal"><b><span
style="font-size:11.5pt;font-family:"Arial","sans-serif";color:black">PamOzer</span></b></div></div>