多表联查的情况总结

普通查询

1. select name,age from students;
2. select * from students;
3. select students.name,students.age from students;
4. select s.name,s.age from students as s;

清除重复行

1. select distinct gender from students;

条件查询

1. select * from students where age>18;
2. select * from students where age>18 and /or age <28;
3. select * from students where not age<=18 and gender=2；年龄不是小于或者等于18 并且是女性
4. select name from students where name=”小%”；或者s