【mysql】如何让student表(表)的信息以学号(列属性)升序/降序显示出来 order by 列名 asc/desc

order by 列名 asc:ascending升序 decs：descending降序  

示例1：

SELECT * FROM student ORDER BY NO ASC
# 查询学生表信息，以学号升序排序显示出来

升序结果：

示例2：

SELECT * FROM student ORDER BY NO DESC
#查询学生表信息，以学号升序降序显示出来

降序结果：

参考文章：
https://blog.csdn.net/weixin_44799217/article/details/112597450?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522164663266316780269862050%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=164663266316780269862050&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2_allfirst_rank_ecpm_v1~rank_v31_ecpm-4-112597450.pc_search_result_cache&utm_term=mysql%E5%88%97%E6%8C%89%E9%80%92%E5%87%8F%E6%8E%92%E5%BA%8F&spm=1018.2226.3001.4187