数据库查询，连接等

数据库查询，连接等

/单表查询/

select * from student2 where classname=‘计算机5班’

/连接查询/

select score as 成绩,rank as 排名
from student3 as a join student2 as b on a.sno = b.sno
where score=‘99’

/外连接/

select *
from student2 as s join student3
on s.sno=student3.sno

/嵌套查询，子查询/

select * from student3
where score= any(
select score from student2
where score>70)

/数据更新/

insert into student3
values (‘100106’,‘65’,‘6’),
(‘100107’,‘62’,‘7’),
(‘100108’,‘60’,‘8’)
select * from student3

/数据删除/

delete from student3 where sno=100101
select * from student3

/视图设计/

Create view cat6
as
select *
from student3
where score=any(
select score from student3
where score>60
)