today:
8
yesterday:
135
Total:
997,797

SQL Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 )

admin 2016.05.06 12:37 Views : 219

SELECT b.customer_id, b.cust_last_name || ', ' || b.cust_first_name cust_name, SUM(a.ORDER_TOTAL) order_total
FROM demo_orders a, DEMO_CUSTOMERS b
WHERE a.customer_id = b.customer_id
GROUP BY b.customer_id, b.cust_last_name || ', ' || b.cust_first_name
ORDER BY NVL(SUM(a.ORDER_TOTAL),0) DESC

I want to
Update Delete List
Write Tag