Re: Getting top 2 by Category

There some ways to do this in one query. Look here:
http://www.sql-ex.ru/help/select16.php

---------------
11.01.11, 22:00, "Ozer, Pam" <pozer@automotive.com>:> This is probably very simple but I am drawing a blank.  Do I need
tocreate a cursor to iterate through a table to grab the top 2 magazines per category?  Here is my table and some data
. The results I need are at the  bottom.  Any help would be greatly appreciated: CREATE TABLE magazinecategory( 
magazinecategoryidsmallint NOT NULL ,  magazineid smallint,  categoryid smallint); INSERT INTO
magazinecategory(           magazinecategoryid, magazineid, categoryid)    VALUES (1, 2, 3);  INSERT INTO
magazinecategory(           magazinecategoryid, magazineid, categoryid)    VALUES (2, 8, 3);  INSERT INTO
magazinecategory(           magazinecategoryid, magazineid, categoryid)    VALUES (3 9, 3);  INSERT INTO
magazinecategory(           magazinecategoryid, magazineid, categoryid)    VALUES (4, 10, 4);   INSERT INTO
magazinecategory(           magazinecategoryid, magazineid, categoryid)    VALUES (5, 11, 4); INSERT INTO
magazinecategory(           magazinecategoryid, magazineid, categoryid)    VALUES (6, 12,4);   The results I want
areCategoryID MagazineID3 23 84 104 11   Pam Ozer>