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
: ...
|
|
