I have table like this
id | name |
---|---|
1 | Apple |
1 | Banana |
1 | Guava |
2 | Cassava |
2 | Carrot |
2 | Potato |
3 | Almond |
3 | Soybeans |
3 | Peanuts |
I want to select only the first one from each id
id | name |
---|---|
1 | Apple |
2 | Cassava |
3 | Almond |
What's the query like?