SQL
SQL
1986ANSI()SQL-SQL86
SQL
3.1 SQL
SQL
SQL
3.2 SQL
SQL
SQL
CREATE TABLE TAB1
SQL
SQL
SQL
[5] “”StudentSnoSnameSsexSageSdept
SQL
);
SQL
CREATE TABLE SC
);
SQL
SQL
SQL
SQL
ALTER TABLE Student ADD Scome DATE
[9]
[10]
SQL
RESTRICT:
CASCADE
SQL
SQL
ON <>(<>[<>][,<>[<>] ]…)
<>
UNIQUE
CLUSTER
SQL
[13]
CREATE UNIQUE INDEX SCno ON SC(Sno ASCCno DESC)
UNIQUE
SQL
StudentSnameStudentSname
SQL
SQL
SELECT
FROM()
WHERE
HAVING
SQL
-
Student
Course
SC
Course(CnoCnameCpnoCcredit)
SC(SnoCnoGrade)
SQL
[2]
2.
FROM Student
SQL
3.
Sname
2006-Sage
1986
1987
1988
1987
SQL
ISLOWER(Sdept)
SQL
ISLOWER(Sdept) DEPARTMENT
FROM Student
SQL
FROM SC;
SQL
2.
WHERE
SQL
SQL
SELECT SnameSdeptSage
[11] 20~23
SELECT SnameSdeptSage
An Introduction to Database System
SQL
<>
SELECT SnameSsex
SELECT SnameSsex
SQL
<>
% () 0
_ ()
SQL
1)
[14] 200215121
SQL
SQL
[19] DB_Design
[20] "DB_"3 i
An Introduction to Database System
SQL
“IS NULL” “= NULL”
[21]
SELECT SnoCno FROM SC
WHERE Grade IS NULL
SQL
An Introduction to Database System
SQL
SELECT SnameSsex
An Introduction to Database System
SQL
SELECT SnameSdeptSage
An Introduction to Database System
SQL
Sno
Grade
200215126
200215129
200215121
92
200215123
90
200215125
88
200215132
85
200215131
60
SQL
SQL
SQL
An Introduction to Database System
SQL
SQL
HAVING
SQL
=><>=<=!=
:
<3>
SQL
(NESTED-LOOP)
2121
1
SQL
SQL
FROM StudentSC
WHERE Student.Sno = SC.Sno
SQL
SQL
WHERE FIRST.Cpno = SECOND.Cno
SQL
——FULL JOIN ON
FROM Student LEFT OUT JOIN SC ON (Student.SNO=SC.SNO)
FROM Student LEFT OUT JOIN SC USINGSno;
SQL
SC.Cno= ‘ 2 ’ AND /* */
SQL
FROM StudentSCCourse
SQL
SQL
SQL
SQL
SQL
SQL
WHERE S1.Sdept = S2.Sdept AND
SQL
FROM Student SnoSname
WHERE Sno IN
WHERE Cname= ‘’));
SQL
SELECT SnoSnameSdept
SQL
SQL
SQL
SQL
FROM Student
SQL
ANYALL
ANYALL
SQL
SQL
SQL
SQL
SQL
SQL
SQL
3.
SELECT SnoSnameSdept
SQL
SQL
SQL
≡ (y (( p∨ q)
SQL
SQL
SELECT *
SQL
An Introduction to Database System
SQL
SQL
(SELECT Sno
FROM SC
SQL
SQL
[<2’> [ASC|DESC] ] … ]
SQL
<>+-*/
SQL
(SELECT) (SELECT)
SQL
(6) [NOT] EXISTS (SELECT)
SQL
3.5.1
SQL
3.5.1
VALUES (<1> [<2>] … )
SQL
VALUES (‘ 200215126 ’‘'''18‘CS')
[1] :200215128IS18Student
INSERT
SQL
SQL
SQL
[WHERE <>]
WHERE
SQL
SQL
WHERE
SQL
SQL
DBMS
SQL
SQL
SQL
ORDER BY DISTINCT
An Introduction to Database System
SQL
:
SELECT
:
SQL
SQL
AS
SQL
AS
SQL
AS
SQL
AS SELECT *
FROM Student
AS
FROM Student
SQL
SQL
SQL
SQL
An Introduction to Database System
SQL
SC.Cno= '1'
SQL
AS
SQL
An Introduction to Database System
SQL
VALUES(‘200215129'''20'IS' )
SQL
An Introduction to Database System
SQL
AS
SQL
DB2
(3)
SQL
SQL
SQL
“”
AS
FROM SXSY
WHERE SX.Sno=SY.Sno
SQL
FROM SC
An Introduction to Database System