dietkinnie Posted July 3, 2009 Share Posted July 3, 2009 Hi Everyone, I am stuck , and would like some inspiration I am trying this sql but not getting the correct result. case when max(price) and product_order = 1 then shelf_id end What i need is the shelf_id of the book with the highest price and has a product order of 1. p.S this is just a small part of the query.... I have really run out of ideas, so any tips would be greatly appreciated. Thanks in advance. //DK Quote Link to comment https://forums.phpfreaks.com/topic/164682-case-max/ Share on other sites More sharing options...
BMurtagh Posted July 3, 2009 Share Posted July 3, 2009 Hey, By going off your post, I think you would need a SQL query along the lines of: SELECT shelf_id WHERE MAX(price) AND product_order = '1' FROM table_name This should at least put you in the right direction to get going. Also, you may want to check out http://www.w3schools.com/sql/default.asp for some additional resources. Quote Link to comment https://forums.phpfreaks.com/topic/164682-case-max/#findComment-868504 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.