i have table like below
h.no
3-5-33/1
3-5-33/97
3-5-33/12
3-5-33/111
3-5-33/2
3-5-33/9
3-5-33/44
display o/p like
3-5-33/1
3-5-33/2
3-5-33/9
3-5-33/12
3-5-33/44
3-5-33/111
iam using select houseno from tablename order by houseno
but o/p not shows above formate
it display like
houseno
3-5-33/1
3-5-33/111
3-5-33/12
3-5-33/2
3-5-33/44
3-5-33/9