A SQL statement

xiaoxiao2021-03-06  42

Three tables

Student S: Learn name Sno Sname

Course C: Course Name CNO CNAME

Student Selection S-C Student Course Sno CNO SCORE

Fill in the blank, in (1) (2) (3) filled in the corresponding statement to the name of the student of all courses Select snamefrom swhere (Select * from c where (2) (Select * from sc Where) (3))))

RESULT:

(1) NOT EXISTS (2) Not exists (3) SNO = S. Sno and CNO = C.CNO

Select Snamefrom Swhere Not Exists (SELECT * from C Where Not Exists (SNO = S.SNO and CNO = C.CNO)))) "From A 9CBS 'Question

转载请注明原文地址:https://www.9cbs.com/read-73051.html

New Post(0)