Çósql command

¸÷λ¸ßÊÖ, ±¾ÈËÏëÒÔÏÂ資ÁÏֻȡÿ隻MODELÖ®×îβORDER NO

modelno  order no
MODELA  A09001
MODELA  A09002
MODELB  A09004
MODELB  A09005
MODELC  A09006
MODELC  A09007

±¾ÈËÏëÒªÖ®´ð°¸ÊÇ
MODELA  A09002
MODELB  A09005
MODELC  A09007

---

select *
from tb A
where not exists (select 1 from tb B where A.modelno=B.modelno and A.orderno <b.orderno)

---

SQL code:
select
*
from
tb t
where
orderno=(select max(orderno) from tb where modelno=t.modelno)

---

SQL code:
select * from tb A
where not exists (select 1 from tb B where A.modelno=B.modelno and A.orderno >b.orderno)

---

http://topic.csdn.net/u/20080626/00/43d0d10c-28f1-418d-a05b-663880da278a.html?85256

---

SQL code:
use tempdb
if object_id('t') is not null drop table t
go
create table t([modelno] varchar(50),[order no] varchar(50))
insert into t
select 'MODELA','A09001' union all
select 'MODELA','A09002' union all
select 'MODELB','A09004' union all
select 'MODELB',