如何查询不在group by后出现的字段

[lyp524]

标题这么写不晓得对不对，具体看例子：

表内容：
id content idplace
1 2009-06-05 上海
1 2009-07-05 广州
2 2009-07-08 北京
3 2009-08-10 北京

要得到的结果
id content idplace
1 2009-06-05 上海
2 2009-07-08 北京
3 2009-08-10 北京

每个id只取一条记录，如遇到相同id的记录，筛选依据是选content字段值小的

原来想用group by ，发现idplace字段没法处理

[百年树人]

select
  *
from
  tb t
where
  not exists(select 1 from tb where id=t.id and content<t.content)

[水族杰纶]

select * from tb t where not exists(select 1 from tb where id=t.id and content<t.content) 

[百年树人]

或者

select 
  *
from 
  tb t
where
  content=(select top 1 content from tb where id=t.id order by content)

[水族杰纶]

select * from tb t where content=(select min(content) from tb where id=t.id )

[feixianxxx]

select
  *
from
  tb t
where
  content in  (select   top 1 content  from tb where id=t.id  order by  content )