Govur University Logo
--> --> --> -->
...

Write a SQL fragment that filters a column named 'ProductName' to include only products containing the word 'Smart' but explicitly excluding any products also containing 'Smartphone'.



The SQL fragment to filter the 'ProductName' column as specified is: `WHERE ProductName LIKE '%Smart%' AND ProductName NOT LIKE '%Smartphone%'`. The `WHERE` clause is fundamental for filtering rows in SQL, specifying the conditions that must be met for a row to be included in the query result. `ProductName` refers to the specific column whose values are being evaluated against the given conditions. The `LIKE....

Log in to view the answer



Redundant Elements