数据库原理及应用孟彩霞版实验3~8 - 图文

SELECT Sno,Grade FROM 学生选课表SC WHERE Cno='1'

ORDER BY Grade DESC;

SELECT *

FROM 学生表Student

ORDER BY Sdept,Age DESC;

1.2 1.2-1 Select*

from Customers where City='上海';

1.2-2

Select goodsname,storage,price,price*0.75 Discount from goods order by price;

1.2-3

Select goodsid,goodsname,price from goods

where goodsname like'%computer%';

1.2-4

Select storage,goodsname,price from goods

where storage between 100and 500;

1.3.1

select sno from SPJ where jno='J1';

3.2

select sno from SPJ

where jno='J1'and pno='P1';

4. 2.1.1

SELECT 学生表Student.*,学生选课表SC.*

FROM 学生表Student,学生选课表SC

WHERE 学生表Student.Sno = 学生选课表SC.Sno;

2.1.2

SELECT 学生表Student.Sno,Sname,Sex,Age,Sdept,Cno,Grade FROM 学生表Student,学生选课表SC

WHERE 学生表Student.Sno = 学生选课表SC.Sno;

2.1.3

SELECT First.Cno,Second.Cpno

FROM 课程表Course First,课程表Course Second WHERE First.CPno = Second.Cno;

2.1.4

SELECT 学生表Student.Sno,Sname,Sex,Age,Sdept,Cno,Grade FROM 学生表Student LEFT OUTER JOIN学生选课表SC