Some doubt in sql query

See more:

ASP.NET

In my application a query result is bind with a Grid View.

the query as ]

SELECT    tbl_DisclosureTypeDetails.disclodetDisclosureId,isnull( tbl_Disclosures.Disclosures,'') AS Expr1,
convert(varchar(20), tbl_BorrowersMasterTemp.BMCurrDate,5),'closed' as status,convert(varchar(20), tbl_DiscloTypeDetailsTemp.dtdTempDate,5)
FROM        ( tbl_DisclosureTypeDetails INNER JOIN
                      tbl_Disclosures ON tbl_DisclosureTypeDetails.disclodetDisclosureId = tbl_Disclosures.DiscId) 
INNER JOIN tbl_DiscloTypeDetailsTemp on tbl_DiscloTypeDetailsTemp.dtdTempDisclosureId=tbl_DisclosureTypeDetails.disclodetDisclosureId 
INNER JOIN tbl_BorrowersMasterTemp on tbl_BorrowersMasterTemp.BMId=tbl_DiscloTypeDetailsTemp.dtdTempId
WHERE     (tbl_DisclosureTypeDetails.disclodetMasterId = (SELECT     BMDisclosure
                            FROM          tbl_BorrowersMaster
                            WHERE      BMId = 221)) and tbl_DisclosureTypeDetails.disclodetDisclosureId not IN(SELECT 
   BMCDisclosures
FROM         tbl_BorrowersMasterChild
WHERE     (BMCBorrowerID = 221)) order by tbl_DisclosureTypeDetails.disclodetDisclosureId

The result of this query is 5 columns .

In this result Two columns values are change as in each row. But other columns are repeated with 5 or more rows.
I can't use group by clause because of each row is different.
So How to I take fifth or latest row in this table.

Out put sample

61 c1 07-05-10 08-05-10
61 c1 08-05-10 08-05-10
61 c1 08-05-10 09-05-20
61 c1 09-06-10 10-06-10
61 c1 10-06-10 11-06-10
61 c1 11-06-10 12-06-10