Can someone help me with writing a SQL statement to show SKU,and Description for

Question

Can someone help me with writing a SQL statement to show SKU,and Description for all products having a description startingwith 'Half-dome';? I keep getting no data displayed when I run thefollowing: SELECT SKU, DESCRIPTION FROM     INVENTORY WHERE   DESCRIPTION='Half-dome'; Can someone help me with writing a SQL statement to show SKU,and Description for all products having a description startingwith 'Half-dome';? I keep getting no data displayed when I run thefollowing: SELECT SKU, DESCRIPTION FROM     INVENTORY WHERE   DESCRIPTION='Half-dome';

Explanation / Answer

Dear,    The SQL statement for the given questionis,       SELECT SKU,DESCRIPTION       FROM INVENTORY       WHERE DESCRIPTION ='Half-done%' ;    Here we have to use the wild card "%" afterthe word 'Half-done', so that it displays all the product detailsstarting with 'Half-done' " I hope this will help you "

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.