lundi 2 mars 2015

Sort table names in Ascending order in SQL

i have a table called Names, where the data is stored like



Raju;
Rakesh;
Preema;
Swetha;
+9199869986;
+9145899656;
+9177885555;
Testing;
Doggy;


Now, if i need to sort by name, i tried like this



"SELECT * FROM namesTable ORDER BY tblNames ASC"


Here i'm getting numbers first, i want numbers to be at the end actual letters from A should appear first.


Any help


Aucun commentaire:

Enregistrer un commentaire