Aspire's Library

A Place for Latest Exam wise Questions, Videos, Previous Year Papers,
Study Stuff for MCA Examinations - NIMCET

Previous Year Question (PYQs)

In SQL, LIKE condition allows you to use wildcard characters to perform matching. Which of the following is a valid wildcard character?




Solution

In SQL, the LIKE operator is used for pattern matching with wildcard characters:

  • % → Matches any sequence of characters (including zero characters).

  • _ → Matches exactly one character.

Example:

SELECT * FROM Students
WHERE Name LIKE 'A%';

This will return all names starting with ‘A’ (like Amit, Anita, Arun, etc.).


Online Test Series,
Information About Examination,
Syllabus, Notification
and More.

Click Here to
View More

Online Test Series,
Information About Examination,
Syllabus, Notification
and More.

Click Here to
View More
Ask Your Question or Put Your Review.

loading...