SQL query Help

[questCorp]

heres the data

Year Type
97 evo
97 evo
97 xtr
98 evo
98 xtr
99 evo
99 xtr
99 xtr

What I need is a DISTINCT list of types for each year i.e. (2 Duplicate results are removed [97 evo & 99 xtr]

Year Type
97 evo
97 xtr
98 evo
98 xtr
99 evo
99 xtr

Thanks
Beau

[LordShryku]

Distinct carries across the selected elements, so just select distinct year, type should work.