Here is an example, hopefully this satisfy what you are looking for
SET DATEFORMAT DMY
create table test
(
id int,
cName varchar(50),
PName Varchar(50),
myDate Datetime
)
go
insert into test values (1,'RAM','abc', cast('28/12/2012' as datetime))
insert into test values (2,'MOHAN','XYZ', cast('28/12/2012' as datetime))
insert into test values (3,'SHYAM','CDF', cast('01/01/2013' as datetime))
insert into test values (4,'FFFF','GHH', cast('01/01/2013' as datetime))
insert into test values (5,'lljl','err', cast('29/01/2013' as datetime))
insert into test values (6,'dfr','dsf', cast('29/01/2013' as datetime))
select top 2 mydate
from test
group by mydate
order by mydate desc
drop table test