Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> how/what should be the query for this result
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! Received on Wed Jun 28 2006 - 09:28:08 CDT