Re: What's wrong with this query ?
Date: Mon, 11 Mar 2002 10:50:56 +1100
Message-ID: <3c8bf0a7$0$16638$afc38c87_at_news.optusnet.com.au>
prehaps include the error msg too?
try...
"Drazen" <drazen_candy__at_gmx.net> wrote in message
news:a6glc2$102$1_at_sunce.iskon.hr...
SELECT * FROM tab
WHERE att in
(select B.att from tab B
group by b.att
having count(*) > 1);
> 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 :)
> ===================================
>
>
Received on Mon Mar 11 2002 - 00:50:56 CET