Assuming your ProductId is a numeric field in SQL then:
SELECT * FROM MyTable WHERE ProductId=1
Will fetch it.
If for some reason it isn't and you have a product id that is string based (VARCHAR from example) then it gets more complex if you are trying to find the data based on a partial string:
SELECT * FROM MyTable WHERE ProductId LIKE '%1%'
May do it, but you will probably have to be rather more explicit about your table design and content, as well as the inputs and results you expect if you want more specific help.