Compare?

How can I compare data in 1 column??
ThanksWhat does that mean?

SELECT *
FROM myTable99 a
INNER JOIN myTable99 b
ON a.Key = b.Key
WHERE a.Col <> b.Col

??????????|||It means that I need to see what names are being duplicated in 1 column.

Thanks|||USE Northwind
GO

SET NOCOUNT ON
CREATE TABLE myTable99(Col1 varchar(25))
GO

INSERT INTO myTable99(Col1)
SELECT 'Apples' UNION ALL
SELECT 'Apples' UNION ALL
SELECT 'Bananas' UNION ALL
SELECT 'Cherries' UNION ALL
SELECT 'Dates' UNION ALL
SELECT 'Eldiberries' UNION ALL
SELECT 'Figs' UNION ALL
SELECT 'Figs' UNION ALL
SELECT 'Guave'
GO

SELECT Col1, COUNT(*)
FROM myTable99
GROUP BY Col1
HAVING COUNT(*) > 1
GO

SET NOCOUNT OFF
DROP TABLE myTable99
GO|||Thanks, very much.

Lystra