数据库SQL语句 --- as,distinct,where(四)

1.as给字段或者表设置别名

as关键字也可省略，也表示设置别名

select name as n,age as a from students;

2.distinct可以去除重复行

select distinct gender from students;

3.where

select * from students where id>3;

4.where and

select * from students where id<5 and gender="女";

5.where not and

select * from students where not(age>18 and age<30);

6.between and(在一个连续的范围内查询)

select * from students where id between 2 and 5;

7.in(在一个非连续的范围内查询)

select * from students where id in (2,4,5);

8.模糊查询 like

%:表示任意多个字符

_:表示任意一个字符

select * from students where name like "张%";

select * from students where name like "张_";

select * from students where name like "张__";

 select * from students where name like "张%" or name like "%安";