SQL Help!

[Wallie12]

I have multiple line of input data as such:
Number, Starttime, Targettime, Endtime
SVR227408,3/24/2010 4:34:24 PM,4/7/2010 4:34:24 PM,4/6/2010 10:35:06 PM
SVR227408,12/7/2009 2:18:27 AM,12/8/2009 9:00:00 PM,12/7/2009 8:43:14 PM
SVR227408,12/7/2009 2:18:27 AM,12/8/2009 9:00:00 PM,12/7/2009 8:43:14 PM
SVR227408,12/7/2009 2:18:27 AM,12/7/2009 8:30:00 PM,12/7/2009 2:19:17 AM ......etc.
SVR224509,
SVR609210,

What I need is the following
SELECT [Number] ---> where Number is Distinct
,[Dateopened]
,[Closed]
,[Starttime]
,[Targettime] ----> and Targettime is MAX
,[Endtime]
FROM [TC].[dbo].[APPLY_DATES_S]

Thanks in advance
Brianmahler@msn.com

 

[r937]

SELECT t.Number 
     , t.Dateopened 
     , t.Closed 
     , t.Starttime 
     , t.Targettime
     , t.Endtime  
  FROM ( SELECT Number
              , MAX(Targettime) AS maxtime
           FROM TC.dbo.APPLY_DATES_S
         GROUP
             BY Number ) AS m
INNER
  JOIN TC.dbo.APPLY_DATES_S AS t
    ON t.Number = m.Number
   AND t.Targettime = m.maxtime

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[Wallie12]

Tried the code. The result I was looking for was:
Number Targettime
SVR349075 4/13/2010 3:30:00 AM<=== this one
SVR349075 4/13/2010 9:00:00 AM
SVR349075 4/9/2010 4:00:00 AM

 

[Wallie12]

I misstated requirements sorry! should be min
Thanks

 

[markros]

Take a look here
Including an Aggregated Column's Related Values
Including an Aggregated Column's Related Values - Part 2

PluralSight Learning Library