Posted by choudharymv on 10/02/08 11:51

I have 1 table "Progress"

P_no b_no status build_date
----------------------------------------------------------------
25 1 First_slab 2006/4/5
25 1 second slab 2006/5/6
25 2 first slab 2006/1/2
25 2 third slab 2006/2/3

o/p should be as
Pno,bno, status, max(build_date)

sample o/p can be as below
25 1 second slab 2006/5/6
25 2 third slab 2006/2/3

Thanks in Advance.

[Back to original message]