JAYRAM

JAYRAM

  • NA
  • 272
  • 213.9k

display order

Mar 16 2014 12:53 AM
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




 

Answers (2)