SQL statement

glj · 10-12-2001, 07:13 AM

Anybody know or can figure out a statement that would do an opposite of a distinct statement
i.e. return all the entries that are duplicate rows.

Cheers

glj

daholygoat · 10-12-2001, 09:29 AM

SELECT DISTINCTROW TempTable.Au_ID,
TempTable.Author, TempTable.[Year Born]
FROM TempTable
WHERE ((
(TempTable.Au_ID) IN
(SELECT [Au_ID] FROM [TempTable] As Tmp
GROUP BY [Au_ID] HAVING Count(*)>1)))
ORDER BY TempTable.Au_ID;

doesn't work on all RDBMS's tho, you might wanna do it through a script instead