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 "