Re: select records from a table
From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 24 Sep 2002 16:13:30 GMT
Message-ID: <3D908F1F.6192F3FF_at_exesolutions.com>
Date: Tue, 24 Sep 2002 16:13:30 GMT
Message-ID: <3D908F1F.6192F3FF_at_exesolutions.com>
yreddy wrote:
> 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
We don't do other people's homework for them.
Give it your best shot ... and if you are still having a problem post your work and we will provide pointers.
But likely you are looking for something using ROWNUM in the WHERE clause.
Daniel Morgan Received on Tue Sep 24 2002 - 18:13:30 CEST