loading
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