Extracting(Display) the data from tables in Certain Conditions(Please help me)

#1 (**permalink**) 07-22-2007, 05:22 AM

1) Give the total sum per order in table item for all orders with an order_id > 600
and a total sum > $25.

Table Contain; Table item (order_id, Item_id, product_id, Actual_price, Quantity, total);

#2 (**permalink**) 07-22-2007, 02:21 PM


SELECT order_id, sum(total) FROM item WHERE order_id >600 GROUP BY order_id HAVING sum(total) > 25;

Hope this helps.

Dimitar

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

User Name		Remember Me?
Password

Extracting(Display) the data from tables in Certain Conditions(Please help me)

ANSWER(S):