Wednesday 9 October 2013

09. You need to create a report displaying the details of all the products that contain the word 'top' near the word 'line' in their description. Write a query to retrieve the desired output. Write the query such that it does not take a long time to execute.

select Description, ProductDescriptionID
from Production.ProductDescription
Where Contains (Description,'"Top" near "Line"')

No comments:

Post a Comment