SELECT *
FROM Stock
where itemid = 6
The statement above returns this:
ItemID Name Weight
6 Parsley 500
The results I want should return the record x number of thimes where x is 3 in the following example:
ItemID Name Weight
6 Parsley 500
6...
Is there a way to specify the number you want to select a specific record? For instace the following select statement return one record:
SELECT *
FROM Stock
where itemid = 6
I want to add code to this statement to return the results x number om times?
CAn anyone help??? Is this possible to do???
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.