代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/446181/7584183
sql 1.5.3.sql
CREATE VIEW CHOICEVIEW
(NO,SID,CID,SCORE)
AS SELECT NO, SID,CID,SCORE
FROM CHOICS
www.eeworm.com/read/446181/7584184
sql 1.2.12.sql
SELECT COURSES.CNAME,CHOICES.SCORE
FROM COURSES,CHOICES
WHERE CHOICES.SID='800009026'
www.eeworm.com/read/446181/7584185
sql 1.2.34.sql
SELECT X.SID
FROM CHOICES AS X,CHOICES AS Y
WHERE X.CID=(
SELECT CID
FROM COURSES
WHERE CNAME='c++'
) AND X.SID=Y.SID AND NOT (
Y.CID=(
SELECT CID
www.eeworm.com/read/446181/7584186
sql 1.6.5.sql
SELECT COUNT(*)
FROM CHOICES
WHERE SCORE IS NULL AND CID='10028'
www.eeworm.com/read/446181/7584188
sql 1.2.31.sql
SELECT TID
FROM CHOICES
WHERE CHOICES.CID=
(
SELECT COURSES.CID
FROM COURSES
WHERE COURSES.CNAME='c++'OR COURSES.CNAME='java'
)
www.eeworm.com/read/446181/7584189
sql 1.3.5.sql
UPDATE STUDENTS
SET GRADE='2002'
WHERE SNAME='LiMing'
www.eeworm.com/read/446181/7584190
sql 1.4.7.sql
INSERT
INTO CS
VALUES ('600000000','823069829','10010',59)
www.eeworm.com/read/446181/7584191
sql 1.1.1.sql
CREATE TABLE PERSON
(P# CHAR(8) NOT NULL UNIQUE,
Pname CHAR(20) NOT NULL,
Page INT,
PRIMARY KEY(P#),CHECK(Page>18))
CREATE TABLE ROOM
(R# CHAR(8) NOT NULL UNIQUE,
Rname CHAR(20),
Rarea FLOA
www.eeworm.com/read/446181/7584192
sql 1.2.19.sql
SELECT STUDENTS.SID,STUDENTS.SNAME,STUDENTS.GRADE,CHOICES.CID,CHOICES.SCORE
FROM STUDENTS JOIN CHOICES ON STUDENTS.SID=CHOICES.SID