kkpop的专栏

转载 [数据库]简单SQL语句总结

全篇以学生成绩的管理为例描述。 1.在查询结果中显示列名：a.用as关键字：select name as 姓名   from students order by ageb.直接表示：select name 姓名   from students order by age 2.精确查找:a.用in限定范围：select * from students where native in (湖南