Amritha.Datta_at_gmail.com wrote:
> Can anyone help me to get results from this tricky query:
>
> Select Recnum, trim(Both From Family_ID), trim(Both From DOB)
> From abc
> Where File_Key = 2470 And Sub_File_Key = 1 and Reason is null and
> trim(Both From Family_ID) IN
> (
> Select trim(Both From Family_ID) From abc Where
> File_Key = 2470 And Sub_File_Key = 1 and Reason is null
> And trim(Both From Family_ID) IN
> (
> select trim(Both From Family_ID) From abc Where
> File_Key = 2470 And Sub_File_Key = 1 and reason is null
> group by trim(Both From Family_ID) having count(trim(Both From
> Family_ID)) > 1
> )
> group by trim(Both From Family_ID), trim(Both From DOB) having
> count(trim(Both From DOB)) > 1
> )
> group by trim(Both From Family_ID), trim(Both From DOB) having
> count(trim(Both From Family_ID) || trim(Both From DOB)) > 1
>
> I know I should not use group by with out all the fields listed in
> select statement. But my intension is to have Recnum based on these
> conditions.
>
> Can anyone come across this kinda issue? Is there any work arrond on
> this ?
>
>
> Thanks.
Do your GROUP BY as an in-line view and then join it in another query
where you grab recnum.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Aug 11 2006 - 11:50:09 CDT
