select records from a table

From: yreddy <yreddy00_at_hotmail.com>
Date: 24 Sep 2002 08:35:45 -0700
Message-ID: <4c9bbf24.0209240735.5f652899_at_posting.google.com>



[Quoted] I have a table with state , county and other columns in the table. I want to retrive 50 rows only for every county in a state, how can i do this? This table is very big and has a lot of rows for a county in a given state. Eg State IL has 34 counties , i want 50 records only per county for the state of IL.

thanks Received on Tue Sep 24 2002 - 17:35:45 CEST

Original text of this message