Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> how/what should be the query for this result

how/what should be the query for this result

From: <choudharymv_at_gmail.com>
Date: 28 Jun 2006 07:28:08 -0700
Message-ID: <1151504888.828136.67230@i40g2000cwc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US