Query Issues 1

[UncleHuckleberry]

I am trying to write a query where a the ID could have more than one category e.g.

ID Category
-- -----------------
1 Category 1
2 Category 2
3 Category 1
4 Category 2

Etc...

What I would like to do is if there is more than one category for an ID select only one of them to eliminate multiple rows for the same id. Whats the best way to do this? Thanks.

 

[Golom]

Your example doesn't have more than one category for an ID. Did you mean something like
[tt]
ID Category
-- -----------------
1 Category 1
1 Category 2
2 Category 1
2 Category 2
[/tt]?
If so, try some SQL like
[tt]
Select ID, MAX(Category) As MaxCategory
From tbl
Group By ID
[/tt]