today:
499
yesterday:
405
Total:
1,013,909

SQL SQL SELECT DISTINCT Statement

admin 2016.04.29 10:07 Views : 169

SELECT distinct c.CUSTOMER_ID , initcap(C.CUST_FIRST_NAME || ' ' || C.CUST_LAST_NAME)  Name, o.ORDER_ID, O.ORDER_TOTAL  
FROM DEMO_CUSTOMERS C, DEMO_ORDERS O, DEMO_ORDER_ITEMS I
where C.CUSTOMER_ID   = O.CUSTOMER_ID   and
      I.ORDER_ID = O.ORDER_ID


------------------------------------------------------

* SQL SELECT DISTINCT Statement

In a table, a column may contain many duplicate values; and sometimes you only want to list the different (distinct) values.

The DISTINCT keyword can be used to return only distinct (different) values.


No. Subject Author Date Views
66 DELETE PROCESS admin 2016.04.28 174
65 UPDATE PROCESS admin 2016.04.28 173
64 JAVA for delete admin 2016.04.28 172
63 Delete Message - Are you sure you want to delete this object? admin 2016.04.28 171
» SQL SELECT DISTINCT Statement admin 2016.04.29 169
61 Column Data 일괄 추가 admin 2023.11.24 166
60 INSERT PROCESS admin 2016.04.28 166
59 MAX admin 2016.04.28 163
58 PHONE NUMBER admin 2016.04.28 162
57 SQL Developer Password change / EXPORT & IMPORT admin 2022.03.18 162
56 wwv_flow_files admin 2016.05.01 159
55 NVL admin 2016.05.19 158
54 CREATE (INSERT) PROCESS admin 2016.04.28 158
53 Forgot Oracle username and password, how to retrieve? admin 2022.03.18 157
52 COUNT admin 2016.04.28 157
51 Field Showing admin 2016.04.01 156
50 Outer Join with Oracle SQL admin 2016.04.29 153
49 BOOLEAN SAMPLE admin 2016.05.11 152
48 LAST DAY SQL admin 2024.01.19 149
47 How to Update Oracle XE admin 2018.04.25 149