tawright915 wrote:
> fitzjarrell_at_cox.net wrote:
>> tawright915 wrote:
>>> I'm trying to pull all records that have mulitpule addresses.
>>>
>>> One account can have more that one address. How would i sort on this?
>>> i tried the lag key word, but I'm not sure this is working for me.
>>>
>>> Thanks
>>> Tom
>> And your current query is?
>>
>>
>> David Fitzjarrell
>
> Good Idea...sorry here it is.
>
> select ky_ba, ky_cust_no, ky_prem_no from bill_acct a
> where (select count(*) from bill_acct b
> where a.ky_cust_no = b.ky_cust_no
> and a.cd_co = '17'
> and a.cd_ba_stat = '02'
> and a.cd_res_comm = 'R') >= 2
> and rownum > 50;
Seems to me that a combination of GROUP BY and HAVING clauses might be
useful.
--
Puget Sound Oracle Users Group
Received on Mon Sep 18 2006 - 12:46:35 CDT
