SQL: Select distinct values from 1 column
Posted
by Parm
on Stack Overflow
See other posts from Stack Overflow
or by Parm
Published on 2009-12-16T23:30:55Z
Indexed on
2010/05/26
23:51 UTC
Read the original article
Hit count: 243
I want to select distinct values from only one column (the BoekingPlaatsId column) with this query:
SELECT MAX(BoekingPlaatsId), BewonerId, Naam, VoorNaam
FROM table
GROUP BY BewonerId, Naam, VoorNaam
How do I do that in SQL Server?
© Stack Overflow or respective owner
