today:
122
yesterday:
311
Total:
1,018,361

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

No. Subject Author Date Views
106 Delimiter admin 2016.04.29 148
105 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 239
104 Outer Join with Oracle SQL admin 2016.04.29 155
103 EXPORT & IMPORT admin 2016.05.01 191
102 wwv_flow_files admin 2016.05.01 168
101 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 124
100 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 150
99 EMPLOYEE_LEVEL_ID admin 2016.05.03 106
» Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 247
97 Interactive Report admin 2016.05.07 138
96 Fundamentals of PL/SQL admin 2016.05.10 2053
95 Display Value, Return Value admin 2016.05.10 139
94 BOOLEAN SAMPLE admin 2016.05.11 160
93 test admin 2016.05.11 143
92 CREATE VIEW admin 2016.05.13 241
91 3D Pie Chart admin 2016.05.17 235
90 TREE admin 2016.05.18 741
89 INSTR admin 2016.05.19 814
88 NVL admin 2016.05.19 175
87 ROWNUM admin 2016.05.19 255