Hi Hilamr,

Thanks for ur solution,
generate the serial nos. that's the only way.
But, still i m in confusion that why select statment is not retriving in order.

With thanks and regards
Abdulla