[sqlite] Insert all rows from old table into new table but in sorted order

[Ajay]

Hello all,

I can insert all rows of existing table into new table having same columns
using query : 

 

Insert into NEWTABLE select * from OLDTABLE 

 

But I want all rows of NEWTABLE sorted by field No,

So I used query 

 

Insert into NEWTABLE select * from OLDTABLE order by no desc

 

But it is not giving me sorted output as new table? 

Can you tell me where I am wrong ???