Group Query

[adwanoy]

Keyword Priority
A 1
A 1
A 2
A 3
B 2
B 3
C 1
C 2
C 3
IN the above data, I want only the top 1 priority for each Keyword, so the results should be:
A 1
B 2
C 1

 

[Golom]

Select   KeyWord, MIN(Priority) As [Lowest Priority]

From     myTable 

Group By KeyWord

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]