问题描述:

I have something like this :

Select id , name from table1 (how to orderby alphabetical from the name(column))

the result from select should be :

1.Alex

2.Bob

3.Charlie

网友答案:

Use this:-

Select id , name from table1 ORDER BY NAME

By default, the order is ascending. If you want to get the names in the descending order use:-

ORDER BY NAME DESC

相关阅读:
Top