What's wrong with this query ?
From: Drazen <drazen_candy__at_gmx.net>
Date: Sun, 10 Mar 2002 23:09:14 +0100
Message-ID: <a6glc2$102$1_at_sunce.iskon.hr>
Eat the candy to see my address better !
Received on Sun Mar 10 2002 - 23:09:14 CET
Date: Sun, 10 Mar 2002 23:09:14 +0100
Message-ID: <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 Sun Mar 10 2002 - 23:09:14 CET