sql where clause but not for some records
Good morning, I have a table where I store some items with prices and
others items without prices.
I want to select all the items with price but in the otherhand I want to
select some items without prices at the same time. Is there any choice to
do this?
Right now I have this select statement:
SELECT DISTINCT TOP 100 PERCENT idItem, itemDescription, price
FROM myTable
WHERE price > 0 and idItem = '000228'
Best regards.
No comments:
Post a Comment