Re: What's wrong with this query ?
Date: Mon, 11 Mar 2002 08:30:17 +0100
Message-ID: <j6no8uod303kv3j8d9ljaclegcvga1tt20_at_4ax.com>
X-Ftn-To: Adam Hart
That's it, so "as tmp" part is not needed,
Thanks,
>prehaps include the error msg too?
>
>try...
>SELECT * FROM tab
>WHERE att in
>(select B.att from tab B
> group by b.att
>having count(*) > 1);
>
>"Drazen" <drazen_candy__at_gmx.net> wrote in message
>news:a6glc2$102$1_at_sunce.iskon.hr...
>> I am trying to find duplicate values in table "tab" in column "att", the
>> query written in Microsoft Access works just fine and in Oracle it does
not,
>> what should it look like? The query is:
>>
>> SELECT * FROM tab WHERE (tab.att IN (SELECT att FROM TAB AS TMP GROUP BY
att
>> HAVING COUNT (*)>1));
>>
>> Regards,
>>
>> Drazen,
>>
>> ===================================
>> Eat the candy to see my address better !
>>
>> Candy spam protection :)
>> ===================================
>>
>>
>
Thanks,
Drazen,
Eat the candy to see my address better !!!
Candy spam protection :)
Received on Mon Mar 11 2002 - 08:30:17 CET