g*******r 发帖数: 1 | 1 rt. Thanks a lot! Bow first!
For example, a table looks like:
name age
amy 28
amy 40
amy 31
bob 12
carl 29
carl 30
...
I want to have a table like:
name age
amy 28
bob 12
carl 29
... | s*****g 发帖数: 939 | 2
Well, try this:
select name, min(age)
from table_name
group by name
【在 g*******r 的大作中提到】 : rt. Thanks a lot! Bow first! : For example, a table looks like: : name age : amy 28 : amy 40 : amy 31 : bob 12 : carl 29 : carl 30 : ...
|
|