thanks all. working now

select top 10 * from dbo.Table_1 and order by DateExpensed ASC

I tried this but again is not working

I tried using this

select TOP 10 from DateExpensed where * from dbo.Table_1 order by DateExpensed ASC

however it has not worked

Thanks all. It worked by changing the OR to AND.

Couldn't see the own fault in my logic -_-