i have table house no like this below coloum.........
house_no
3-13-10
3-13-200/a
3-13-450/a
3-13-1345/b
3-13-4
3-13-567/c
3-13-832/a
3-13-943
i want table like this....
3-13-4
3-13-10
3-13-200/a
3-13-450/a
3-13-567/c
3-13-832/a
3-13-943
3-13-1345/b
pl write the quarie