Since you say:
;;;I am using ASP for getting data from database and display
I assume your query is working ok? Not sure why urtrivedi altered it..... Anyhow to order an existing working query you simply append:
" ...... ORDER BY [yourDateFieldName];"
NOTE - Its a good practice to place trailing semi colons at the end of any query. I assume 'yourDateFieldName' is a date data type? It needs to be to get what you want. Remember things are ordered ascending by default. To reverse this you need to place DESC at the end of the query
Wind is your friend