摘要:
1.在查询结果中显示列名: a.用as关键字:select name as '姓名' from students order by age b.直接表示:select name '姓名' from students order by age 2.精确查找: a.用in限定范围:select * from students where native in ('湖南', '四川') b.between...and:select * from students where age between 20 and 30 c.“=”:sele 阅读全文