Homework Help is Here – Start Your Trial Now!
Engineering
Data Structures and Algorithms
To select records from a table for whose first names are neither Jerry nor Cosmo, which of the following WHERE clause is correct? O a. WHERE FirstName = 'Jerry' OR FirstName = 'Cosmo'; O b. WHERE FirstName = 'Jerry' AND FirstName = 'Cosmo'; O c. WHERE FirstName <> 'Jerry' OR FirstName <> 'Cosmo'; O d. WHERE FirstName NOT IN ('Jerry', 'Cosmo');

To select records from a table for whose first names are neither Jerry nor Cosmo, which of the following WHERE clause is correct? O a. WHERE FirstName = 'Jerry' OR FirstName = 'Cosmo'; O b. WHERE FirstName = 'Jerry' AND FirstName = 'Cosmo'; O c. WHERE FirstName <> 'Jerry' OR FirstName <> 'Cosmo'; O d. WHERE FirstName NOT IN ('Jerry', 'Cosmo');

icon
Related questions
Question
To select records from a table for whose first names are neither Jerry nor Cosmo, which of the following WHERE clause is correct? O a. WHERE FirstName = 'Jerry' OR FirstName = 'Cosmo'; O b. WHERE FirstName = 'Jerry' AND FirstName = 'Cosmo'; O c. WHERE FirstName <> 'Jerry' OR FirstName <> 'Cosmo'; C. O d. WHERE FirstName NOT IN ('Jerry', 'Cosmo');
Transcribed Image Text:To select records from a table for whose first names are neither Jerry nor Cosmo, which of the following WHERE clause is correct? O a. WHERE FirstName = 'Jerry' OR FirstName = 'Cosmo'; O b. WHERE FirstName = 'Jerry' AND FirstName = 'Cosmo'; O c. WHERE FirstName <> 'Jerry' OR FirstName <> 'Cosmo'; C. O d. WHERE FirstName NOT IN ('Jerry', 'Cosmo');
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer