当前位置: 动力学知识库 > 问答 > 编程问答 >

oracle - how to select with order by alphabetical

问题描述:

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

分享给朋友:
您可能感兴趣的文章:
随机阅读: