Re: What's wrong with this query ?

From: Drazen <drazen_candy__at_gmx.net>
Date: Mon, 11 Mar 2002 00:14:08 +0100
Message-ID: <a6gp89$3hl$1_at_sunce.iskon.hr>


Still doesn't work .....

"Ryan Gaffuri" <rkg100_at_erols.com> wrote in message news:a6gn12$5s$1_at_bob.news.rcn.net...
> You dont need the '(' around the Where clause.
> "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 :)
> > ===================================
> >
> >
>
>
Received on Mon Mar 11 2002 - 00:14:08 CET

Original text of this message