-
Junior Member
Select specific purchase price
How to write a query to if you need to see only the products for a particular price. For example, I need to only see products that have 980 as the last three digits of the purchase price. The products column is call vehicles, the price column is called list_price, the table is table_inventory.
Please Help!
-
Junior Member
Re: Select specific purchase price
u can try this one
select productname from tablename
where purchaseprice like '%980'
-
Expert Member
Re: Select specific purchase price
Try this
SELECT vehicles,list_price
From table_inventory
WHERE list_price like '%980'
-
Expert Member
Re: Select specific purchase price
You may get the result in this way also
SELECT vehicles,list_price
FROM table_inventory
WHERE substr(list_price,-3,length(list_price)) = '980'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules