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
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
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)
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]