how to select only 2nd record

[ddtpmyra]

I dont have my syntax now but here what I wanted to do...

I have multiple rows under field name DateNote
10/10/2010
10/11/2010
10/12/2010

obviously when i get the minimun date it will give me the earliest which is 10/10/2010. Now what i wanted is after teh get the most earliest I wanted to catch the 2nd date after 10/10/2010 which is 10/11/2010.

Please help

[gpl]

Try getting the minimum date that is larger than the real minimum date

[NeoPa]

For a more general solution to the nth record, use the TOP predicate of n, then select the MAX() (or MIN() depending on sort order) of the returned result. IE use the TOP within a subquery.

[ck9663]

What do you have so far?

~~ CK

[ddtpmyra]

I use outer apply and it works for me thanks for the help!

OUTER APPLY  
    (SELECT TOP 1  um.modifieddate as FirstRespDate, um.TaskNoteTypeId
     FROM dbo.TaskNote um (NOLOCK) 
             where um.TaskNoteTypeId=2 and um.woid = t.WOID
             and um.modifieddate is not null
             order by um.ModifiedDate) as mbg