Thanks for ur response...........

 But my question is that then why does people say that the order of the data is in accordance to the clustered indexed column if it exist....

But When we say that column with clustered index always orders the table  then why its not showing the correct results.

But if I use 3 columns then it orders...

I have question where there is a  table with two columns :

1. ID(PK, with non clustered index) 

2. Address(clustered index) 

When we insert data in the table it is not reordering the data based on...