today:
66,233
yesterday:
36,263
Total:
9,693,729

Oracle APEX SQL

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

admin 2016.05.06 12:37 Views : 1392

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
32 Display Value, Return Value admin 2016.05.10 1198
31 Fundamentals of PL/SQL admin 2016.05.10 3335
30 Interactive Report admin 2016.05.07 1145
» Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 1392
28 EMPLOYEE_LEVEL_ID admin 2016.05.03 1144
27 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 1224
26 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 1040
25 wwv_flow_files admin 2016.05.01 1232
24 EXPORT & IMPORT admin 2016.05.01 1391
23 Outer Join with Oracle SQL admin 2016.04.29 1270
22 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 1391
21 Delimiter admin 2016.04.29 1249
20 SQL SELECT DISTINCT Statement admin 2016.04.29 1474
19 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 1268
18 COUNT admin 2016.04.28 1260
17 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 1269
16 CREATE (INSERT) PROCESS admin 2016.04.28 1266
15 DELETE PROCESS admin 2016.04.28 1275
14 Global & Custom Serach file admin 2016.04.28 1454
13 INSERT PROCESS admin 2016.04.28 1276
Write Tag