RE: SELECT identical datas from one table
Jenderka,
Try
SELECT barf,COUNT(*)
FROM foobar
GROUP BY 1
HAVING COUNT(*) > 1
Which should give you any duplicated data.
Chris.
-----Original Message-----
From: jenderka@my-deja.com [mailto:jenderka@my-deja.com]
Sent: 28 August 2000 11:24
To: informix-list@iiug.org
Subject: SELECT identical datas from one table
I need SELECT expression to select all rows from one table
where identical datas exist in one column.
But I don't still know whether these datas exist.
Therefore I cannot use WHERE.
Have a nice day!
--
Jenderka Vlastimil
jenderka@post.cz
Sent via Deja.com http://www.deja.com/
Before you buy.