how/what should be the query for this result
- From: choudharymv@xxxxxxxxx
- Date: 28 Jun 2006 07:28:28 -0700
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.
.
- Follow-Ups:
- Re: how/what should be the query for this result
- From: Alexander Kuznetsov
- Re: how/what should be the query for this result
- From: Erland Sommarskog
- Re: how/what should be the query for this result
- Prev by Date: Re: Combining 2 tables with date ranges
- Next by Date: Re: how/what should be the query for this result
- Previous by thread: Datareader concepts to access SQL Server data using datareader.
- Next by thread: Re: how/what should be the query for this result
- Index(es):