Comments by Madhu from Bangalore (Top 2 by date)

Thank you for your response.
I am new to SQL Server . now i am in learning stage
the above table is simple table i created and there is no keys and orders like DESC and ASC.
so give me how many ways are there to return reverse order like 0101.
and you mentioned in order by clause is "(select 1)" what is that purpose?
please give brief informatin