Питання | Сторінка 112270

Which question best fits the following query?

SELECT *

FROM COURSES

WHERE CTITLE LIKE '%SQL%'

AND CID NOT IN ('7800','7820')

Display the first row of the table COURSES whose column CTITLE is equal to %SQL% and whose value in column CID is neither 7800 nor 7820.

Display the first row of the table COURSES whose column CTITLE contains the characters SQL and and whose value in column CID is not between 7800 and 7820.

Display the first row of the table COURSES whose column CTITLE is equal to %SQL% and whose value in column CID is not between 7800 and 7820.

Display all the rows of the table COURSES whose column CTITLE is equal to %SQL% and whose value in column CID is not between 7800 and 7820.

Display all the rows of the table COURSES whose column CTITLE contains the characters SQL and whose value in column CID is neither 7800 nor 7820.

Display all the rows of the table COURSES whose column CTITLE contains the characters SQL and and whose value in column CID is not between 7800 and 7820.

Display the first row of the table COURSES whose column CTITLE contains the characters SQL and whose value in column CID is neither 7800 nor 7820.

Display all the rows of the table COURSES whose column CTITLE is equal to %SQL% and whose value in column CID is neither 7800 nor 7820.

Переглянути це питання

Crowdly

Questions Bank (1356857 total)