πŸ“Š MySQL
Q. What will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE lname LIKE ‘F%’ OR lname LIKE ‘%T’;
  • (A) All employees whose last name should started with 'F'
  • (B) All employees whose last name end with 'T'
  • (C) All employees whose last name should started with 'F' and end with 'T'
  • (D) None of the mentioned
πŸ’¬ Discuss
βœ… Correct Answer: (C) All employees whose last name should started with 'F' and end with 'T'

Explanation: This question is asking about how to use the LIKE operator in MySQL to find employees with specific patterns in their last names. Let's break it down:

Explanation by: Vijay Sangwan
This question is asking about how to use the LIKE operator in MySQL to find employees with specific patterns in their last names. Let's break it down:

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
79
Total Visits
πŸ“½οΈ
12 mo ago
Published
πŸŽ–οΈ
Vijay Sangwan
Publisher
πŸ“ˆ
88%
Success Rate