Tossing out duplicates 1

[Sashanan]

I am trying to select all unique values in a column, while tossing out any duplicates so every value shows up only once. I know there was an easy way to do this; now if only I could remember what it was.

SELECT Column1
FROM Table1
ORDER BY Column1

Can anyone refresh my memory and tell me what I need to add to this to toss out the duplicates?
"Much that I bound, I could not free. Much that I freed returned to me."
(Lee Wilson Dodd)

 

[Tim1]

Hiya,

If you just want to see unique values, what you need is :

SELECT DISTINCT Column1
FROM Table1
ORDER BY Column1

If you want to see duplicate values, you need

SELECT Column1
COUNT(*)
FROM Table1
GROUP BY Column1
HAVING COUNT(*) > 1

Tim

 

[Tim1]

Hiya,

If you just want to see unique values, what you need is :

SELECT DISTINCT Column1
FROM Table1
ORDER BY Column1

If you want to see duplicate values, you need

SELECT Column1
COUNT(*),
FROM Table1
GROUP BY Column1
HAVING COUNT(*) > 1

Tim

 

[Sashanan]

DISTINCT! That was it. Thank you for reminding me.

21 years and already forgetful. I sure hope I never get to program something important.
"Much that I bound, I could not free. Much that I freed returned to me."
(Lee Wilson Dodd)