Vishal Patil

Vishal Patil

  • NA
  • 66
  • 393

Sort data in numeric first and then varchar format

Apr 18 2018 12:11 AM
i have a table which consist a column as
45
55
47
AB
56
AC
43
 
and i want to sort as 
45
55
47
56
43
AB
AC
 
means numeric first and then string and without sort by asc or desc 
 
how to do it please suggest me 

Answers (2)