Introduction to SQL

Q1: The SQL keyword(s) ________ is used with wildcards.

A LIKE only

B IN only

C NOT IN only

D IN and NOT IN

ANS:A - LIKE only

A wildcard character can be used to substitute for any other character(s) in a string. SQL wildcards are used to search for data within a table.

For Example1:
SELECT * FROM Customers
WHERE City LIKE 'ber%';
//Displays table containing city starting with Ber...//

For Example2:
SELECT * FROM Customers
WHERE City LIKE '%es%';
//Displays table containing city ending with es...//



img not found
img

For help Students Orientation
Mcqs Questions

One stop destination for examination, preparation, recruitment, and more. Specially designed online test to solve all your preparation worries. Go wherever you want to and practice whenever you want, using the online test platform.