MCQs>Database Management>Transact-SQL (T-SQL)>You need to write a query that returns all products that have a SerialNumber ending with "10_3". Which WHERE clause should you use to fill in the blank in this query?SELECT ProductID, ProductName, SerialNumber FROM Products______ ;
Transact-SQL (T-SQL) MCQs
You need to write a query that returns all products that have a SerialNumber ending with "10_3". Which WHERE clause should you use to fill in the blank in this query?SELECT ProductID, ProductName, SerialNumber FROM Products______ ;
Answer
Correct Answer: WHERE SerialNumer LIKE '%10_3'
Explanation:
Note: This Question is unanswered, help us to find answer for this one