exists 存在:
select name
from student
where
exists select name from sc where sc.name=student.name; 从student 表中查找 存在于sc表中的学生;即两个表同时都有的学生。
like 模糊查找:
select name from student where neme like ‘李%’;
找姓李的学生
left() right()函数:
select left(name,1) from student //查找student表中所有的姓
in :
select name
from student
where
id in (select id from sc where cno=100 ) //查找在课程100里面和学生表里面都存在的学生