Re: sql issue

From: Bricklen <bricklen_at_shaw.ca>
Date: Thu, 26 Sep 2002 14:51:17 GMT
Message-ID: <3D931D45.8202376F_at_shaw.caX>


Sounds like an excellent time to use some analytic functions. check out this link:
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/function.htm#81409 for more details.

yreddy wrote:
>
> I have a table with state , county and many more columns, i want to
> select 50 rows for every county in a state. This table has all the
> states and multiple counties per state. I am not worried about
> duplicate counties or anything. Just want the 50 records for every
> county in all the states
>
> thanks
Received on Thu Sep 26 2002 - 16:51:17 CEST

Original text of this message