today:
503
yesterday:
793
Total:
1,014,706

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

admin 2016.05.06 12:37 Views : 242

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
No. Subject Author Date Views
86 eeeeee admin 2018.06.21 235
85 If you want to use EXISTS in a PL/SQL function returning BOOLEAN admin 2018.05.19 233
84 CREATE VIEW admin 2016.05.13 233
83 Process admin 2018.05.05 231
82 3D Pie Chart admin 2016.05.17 230
81 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 230
80 IF/ELSE ... CASE WHEN admin 2018.06.25 217
79 use a validation function for an element in apex 5.0 admin 2018.05.19 217
78 All Data DELETE from Table admin 2018.05.10 217
77 MISSIONARY_SUB admin 2018.06.25 213
76 Name Show admin 2016.04.28 212
75 How to convert DATE to NUMBER admin 2018.05.27 205
74 TABLE PRINT admin 2018.06.18 201
73 Apex setup procedure admin 2016.04.28 189
72 Captcha Test file admin 2016.04.18 188
71 CREATE TABLESPACE admin 2016.04.28 186
70 Using SQL*Plus to Unlock and Change Passwords admin 2023.06.04 185
69 EXPORT & IMPORT admin 2016.05.01 180
68 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 177
67 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 175
Write Tag