Re: How do i sort by

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Mon, 18 Sep 2006 22:15:29 +0200
Message-ID: <eemup2$gv1$02$1@news.t-online.com>

DA Morgan schrieb:

> 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.

Apart from that, rownum > 50 always evaluates to false, hence ,result set should yield no rows.

Best regards

Maxim Received on Mon Sep 18 2006 - 15:15:29 CDT