Re: What's wrong with this query ?

From: Drazen <drazen_candy__at_hotpop.com>
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

Original text of this message