SQL??急急

[dovei]

select part.id,part.description,max(a.trans_date)as bb,(a.plan_no) as plan_no
from part left join Inv_Trans_Detail a on a.part_id = part.id
where classified_id = '349'
group by part.id,part.description,a.plan_no
order by bb desc ,part.id
執行結果如下：
11023434 灰428C 反毛皮 1.2-1.4mm 2009-04-20 21:29:44.907 P-I50899-1
11023434 灰428C 反毛皮 1.2-1.4mm 2009-04-20 21:29:44.907
11023434 灰428C 反毛皮 1.2-1.4mm 2009-04-20 21:29:44.907 P-I50901-1
11000105 黑 袋鼠皮 0.7-0.8mm 2009-04-21 17:19:05.873 P-I60644-1
11000105 黑 袋鼠皮 0.7-0.8mm 2009-04-21 17:19:05.873 P-I50642-1
11029807 深棕 反毛皮 1.4-1.6mm 2009-04-17 21:04:28.743 P-HC2739-1
11029807 深棕 反毛皮 1.4-1.6mm 2009-04-17 21:04:28.743 P-HC2739-2
現需過濾成如下形式結果：
11023434 灰428C 反毛皮 1.2-1.4mm 2009-04-20 21:29:44.907 P-I50901-1
11000105 黑 袋鼠皮 0.7-0.8mm 2009-04-21 17:19:05.873 P-I60644-1
11029807 深棕 反毛皮 1.4-1.6mm 2009-04-17 21:04:28.743 P-HC2739-2

SQL語句該如何寫？？？

[jinjazz]

select part.id,part.description,max(a.trans_date)as bb,max(a.plan_no) as plan_no
from part left join Inv_Trans_Detail a on a.part_id = part.id
where classified_id = '349'
group by part.id,part.description
order by bb desc ,part.id

[SQL77]

来学习,好像不得加一个条件吧,按那个PLAN_NO

[-晴天]

select sid=identity(int,1,1),part.id,part.description,max(a.trans_date)as bb,(a.plan_no) as plan_no into #
from part left join Inv_Trans_Detail a on a.part_id = part.id 
where classified_id = '349' 
group by part.id,part.description,a.plan_no 
order by bb desc ,part.id 
select * from # a where sid=(select min(sid) from # where id=a.id group by id)

[SQL77]

[code=SQL][/cselect part.id,part.description,max(a.trans_date)as bb,max(right(a.plan_no,3)) as plan_no
from part left join Inv_Trans_Detail a on a.part_id = part.id
where classified_id = '349'
group by part.id,part.description
order by bb desc ,part.id ode]