Thanks Vladan,

Even I actaully realiazed it at the end of the day. It was actaully a quick solution and I just bunked off from my  work to answer it. Sheer...

Hi,

You can also do it like this:

Select top 2 * from (select top 2 * from  order by date desc) TempTest

order by date

Remember, it has performance issues ...