Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 11)
11.
The SQL keyword(s) ________ is used with wildcards.
Discussion:
14 comments Page 2 of 2.
Vikas said:
1 decade ago
Like keyword used two wildcard 1. '_' for single character, 2. '%'for multiple character.
Ali said:
1 decade ago
Using the _ Wildcard.
Now we want to select the persons with a first name that starts with any character, followed by "la" from the "Persons" table. We use the following SELECT statement:
SELECT * FROM Persons WHERE FirstName LIKE '_la'
Now we want to select the persons with a first name that starts with any character, followed by "la" from the "Persons" table. We use the following SELECT statement:
SELECT * FROM Persons WHERE FirstName LIKE '_la'
Sufi said:
9 years ago
Thanks, Now my doubt on wildcard is much cleared.
Argha Sarkar said:
8 years ago
Thank you.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers