求一select语句：取字段最大值

[三色]

表tbl结构如下
model sort time
modelA 创建 2011-1-1 1:0:0
modelA 删除 ...
modelA 修改 ...
modelA 修改 ...
modelA 修改 ...
modelB 创建 ...
modelB 删除 ...
modelB 修改 ...
modelB 修改 ...
modelC 修改 ...
...

想要select的结果条件
1，sort='删除'
2，time取同一model下最大值

请问select语句怎么写

[NBDBA]

select * from tbl a
where sort='删除'
and not exists (
  select 1
 from tbl
 where model=a.model 
 and time>a.time
 )

[NBDBA]

从搂主得表述理解写的，可能没有数据返回
因为搂主没说明
2，time取同一model下最大值
这个条件是否受
1，sort='删除'
限制

[AcHerat]

select model,max(time) time
from tb
where sort = '删除'
group by model

[三色]

[Quote=引用 1 楼 nbdba 的回复:]
SQL code

select * from tbl a
where sort='删除'
and not exists (
select 1
from tbl
where model=a.model
and time>a.time
)
[/Quote]

测试通过，谢谢

[快溜]

select * from tbl a
where sort='删除' and time=(select max(time) from tbl where model=a.model 

[chuanzhang5687]

select * from tbl a
where sort='删除' and time=(select max(time) from tbl where model=a.model 

[--小F--]

select * from tbl t where sort='删除' and time=(select max(time) from tbl where model=t.model)