today:
1,061
yesterday:
1,216
Total:
1,009,657

SQL COUNT

admin 2016.04.28 13:36 Views : 150

* COUNT 1 *
select distinct count (CUSTOMER_ID) from DEMO_CUSTOMERS;

* COUNT 2 *
select count (CUSTOMER_ID)
   from DEMO_CUSTOMERS
where instr(upper(CUST_LAST_NAME), upper  ( nvl (:P1_CUST_LAST_NAME,CUST_LAST_NAME))) > 0

AND instr(upper(CUST_FIRST_NAME), upper  ( nvl (:P1_CUST_FIRST_NAME,CUST_FIRST_NAME))) > 0

order by 1


* COUNT 3 *

select count (*) from (
select CUSTOMER_ID, Initcap( CUST_LAST_NAME ||','|| CUST_FIRST_NAME   ) Name, 
CUST_CITY, CREDIT_LIMIT, CUST_EMAIL, NLS_TERRITORY,
case ACCOUNT_MGR_ID
  when   1 then 'John'
    when   2 then  'Bill'
    when 3 then 'Smith'
   when  4 then 'Joe'
        when 5 then 'Ron' else
         'N/A'
         end as MGR_id
   from DEMO_CUSTOMERS
where instr(upper(CUST_LAST_NAME), upper  ( nvl (:P1_CUST_LAST_NAME,CUST_LAST_NAME))) > 0

AND instr(upper(CUST_FIRST_NAME), upper  ( nvl (:P1_CUST_FIRST_NAME,CUST_FIRST_NAME))) > 0

order by 1)
where (
 instr(upper("NAME"),upper(nvl(:P1_SEARCH,"NAME"))) > 0  or
 instr(upper("CUST_CITY"),upper(nvl(:P1_SEARCH,"CUST_CITY"))) > 0  or
 instr(upper("CUST_EMAIL"),upper(nvl(:P1_SEARCH,"CUST_EMAIL"))) > 0  or
 instr(upper("NLS_TERRITORY"),upper(nvl(:P1_SEARCH,"NLS_TERRITORY"))) > 0  or
 instr(upper("MGR_ID"),upper(nvl(:P1_SEARCH,"MGR_ID"))) > 0
)

No. Subject Author Date Views
26 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 117
25 wwv_flow_files admin 2016.05.01 155
24 EXPORT & IMPORT admin 2016.05.01 176
23 Outer Join with Oracle SQL admin 2016.04.29 148
22 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 222
21 Delimiter admin 2016.04.29 142
20 SQL SELECT DISTINCT Statement admin 2016.04.29 163
19 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 171
» COUNT admin 2016.04.28 150
17 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 175
16 CREATE (INSERT) PROCESS admin 2016.04.28 154
15 DELETE PROCESS admin 2016.04.28 164
14 Global & Custom Serach file admin 2016.04.28 130
13 INSERT PROCESS admin 2016.04.28 160
12 JAVA for delete admin 2016.04.28 165
11 LIST OF VALUE (DYNAMIC) admin 2016.04.28 129
10 MAX admin 2016.04.28 158
9 Name Show admin 2016.04.28 204
8 PHONE NUMBER admin 2016.04.28 155
7 UPDATE PROCESS admin 2016.04.28 170