Re: How do i sort by

From: tawright915 <tawright915_at_gmail.com>
Date: 18 Sep 2006 09:41:39 -0700
Message-ID: <1158597699.776224.76050@e3g2000cwe.googlegroups.com>

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; Received on Mon Sep 18 2006 - 11:41:39 CDT