代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/446181/7584153
sql 1.4.3.sql
CREATE VIEW SCC
(SNAME,CNAME,SCORE)
AS SELECT STUDENTS.SNAME,COURSES.CNAME,CHOICES.SCORE+5
FROM CHOICES,STUDENTS,COURSES
WHERE CHOICES.CID=COURSES.CID AND CHOICES.SID=STUDENTS.SID
www.eeworm.com/read/446181/7584155
sql 1.2.11.sql
SELECT SID
FROM CHOICES
GROUP BY SID
HAVING COUNT(*)>3
www.eeworm.com/read/446181/7584157
sql 1.2.13.sql
SELECT CHOICES.SID
FROM CHOICES,COURSES
WHERE CHOICES.CID=COURSES.CID AND COURSES.CNAME='database'
www.eeworm.com/read/446181/7584158
sql 1.4.4.sql
CREATE VIEW S_G(SID,SAVG)
AS
SELECT SID,AVG(SCORE)
FROM CHOICES
GROUP BY SID
www.eeworm.com/read/446181/7584159
sql 1.4.2.sql
CREATE VIEW SCT
(SNAME,CNAME,TNAME)
AS SELECT STUDENTS.SNAME,COURSES.CNAME,TEACHERS.TNAME
FROM CHOICES,STUDENTS,COURSES,TEACHERS
WHERE CHOICES.TID=TEACHERS.TID AND CHOICES.CID=COURSES.CID AND CHOI
www.eeworm.com/read/446181/7584160
sql 1.2.24.sql
SELECT CNAME
FROM COURSES
WHERE CID NOT IN
( SELECT CID
FROM CHOICES
)
www.eeworm.com/read/446181/7584162
sql 1.2.17.sql
SELECT X.CID
FROM CHOICES AS X,CHOICES AS Y
WHERE X.CID=Y.CID AND X.NO