sql - Query Error, cant display correctly -


There is an error in my query, I try to display the date, the data name (which is POS and non-POS) And the number of data

desired output: 

  02/20/2014, POS, 40 02/20/2014, non-POS, 15  < / Pre> 
 question:  
  select TO_CHAR (D.dtime_day, 'mm / dd / yyyy') to join in owner_dwh.dc_date d (select count (case Left when upper (t.ticket_customer_user_id) = upper ('POS normal') then 1 and zero end) --POS || ',' || calculation ( The case is when the upper (t.ticket_customer_user_id) = upper ('hcphuser' then 1 and zero end) from the app_account - user.strrs_ticket T WHERE Trunc (t.create_time, 'DAY') between SYSDATE - 119 and SYSDATE - Trunc Left d.dtime_day = t.create_time at 1 group (t.create_time, 'DAY')) (selection number (case when upper (t.ticket_customer_user_id) = upper ('position') then 1 and zero end) - POS || ',' || Calculation (case when upper (t.ticket_customer_user_id) = upper ('user') then 1 and NULL END) - User by app_account.tars_ticket T WHERE Trunc (T.Code_Tit, 'DAY') Between- SYSDATE - 119 and SYSDATE - Tr 1 group by unc (t.code. Time, 'DAY')) d.dtime_day = t at close_time WHERE t.queue_id (63, 61, 69, 59, 58, 60, 56, 64, 65, 23, 67, 68, 57);   
 My error:  
  ORA-00904: "T". "CREATE_TIME": Invalid identifier 00 9 04. 00000 - "% s: invalid identifier"   
 Data is DTIME_DAY (OWNER_DWH.DC_DATE) like this:  
  02/12/2014 02/13/2014 02/14/2014   
 While in app_count.otts.ticket  
 create_time and close_time open and close ticket The date is TORET_CUSTOMER_USER_ID in POS-generic and user (like its category)  
 Please help me and fix my query. Thank you in advance.   
 
 
 You will need to repeat the nickname outside the parentheses:  
  SELECT To_char ( D.dtime_day, 'MM / dd / yyyy') FROM (owner_dwh.dc_date d is omitted (selection number (case when upper (t.ticket_customer_user_id) = upper ('POS-generic') then 1 and zero end) - -POS || ',' || Calculation (case when upper (t.ticket_customer_user_id) = upper ('hcphuser' then 1 and zero end), - user t.create_time - !!! Of course, this field Do not think about returning! Ap_account.Totrics_ticketT WHERE Trunc (t.create_time, 'DAY') Between, SYSDATE - 119 and SYSDATE-1 and t.queue_id IN (63, 61), 69, 59, 58, 60, 56, 64, 65, 23, 67, 68, 57) Group by trunk (T. Crete_TyT , 'Day')) TD timeted = T. kreate_time) left count (select calculation (case when upper (t.ticket_customer_user_id) = upper ('condition') then 1 and zero end) --POS || ', 'Count (case when upper (t.ticket_customer_user_id) = upper (' user ') then 1 to the end of the cancellation faucet), --USER T.close_time - Return from subcategory !!!! From APP_account.otrs_ticket T TRUNC (t.close_time, 'days') between SYSDATE - 119 and SYSDATE - 1 and not in t.queue_id (63, 61, 69, 59, 58, 60, 56, 64, 65, 23, 67, 68, 57) Group by trunc (T.close_youm, 'de')) D on U. Dreamtime_de = U.Close_time - you can not use T twice to join !!!   
 All this can be collected by your query ...

Comments

Post a Comment

Popular posts from this blog

c - Mpirun hangs when mpi send and recieve is put in a loop -

I was trying to use the program to use mifrewan on 4 node clusters. Distributing node 0 data in nodes 1, 2 and 3. In the program, from '90 'to variable values ​​of' dior 'to be calculated. Therefore the node is distributing data and collecting results in an omitted fashion (for different values ​​of var 'dir') when do {*******} Whereas (dir Loop is given, Mippun is hanging, and no output is found. But when I comment on two {*******} (dir The loop output is obtained for the initial value of variable dir dir = -90 ), and that output is correct. The problem occurs when the loop is given. Can anyone help me in solving this problem. #include "mpi.h" int main (int argc, char * argv []) Float dir = -90; Int rank, nanoprakash; MPI_Status status; MPI_Init (& amp; argc, & argv); MPI_Comm_rank (MPI_COMM_WORLD, & amp; Rank); MPI_Comm_size (MPI_COMM_WORLD, & amp; numprocs); If (rank == 0) {/ / data to begin / / (dest = 1; dest ...
Read more

python - Apply coupon to a customer's subscription based on non-stripe related actions on the site -

I can not find anything in the source about using coupons after subscribing to a user's plan. Is it possible to use a coupon to credit a user's membership after initial subscription? If not, what is the best option? Specifically, I want to give a user 100% coupon for that month, when they take 5 [site specific actions]. This is possible, but may not be the best idea. Coupons are currently applied to the stripe, then apply again at the customer level and each client can have a single coupon. So if you are already offering discounts to the coupon, then the customer who is currently in the present will also give up. It also means that if you are using a recently-added multiple subscription capacity, then all of the user's subscription will be ready for the month. Coupons can be set to "Once", only once (as the only name) can be used by any customer, so if this credit can earn more than once, You will have to maintain a 100% discount coupon continuousl...
Read more

java - Unable to get JDBC connection in Spring application to MySQL -

मैंने स्प्रिंग में डीबी कॉन्फ़िगरेशन का पालन किया है: & lt; bean id = "dataSource" Class = "org.apache.commons.dbcp.BasicDataSource" नष्ट-विधि = "बंद" & gt; & Lt; प्रॉपर्टी नाम = "url" मान = "jdbc: dburl" / & gt; & Lt; संपत्ति नाम = "driverClassName" मान = "com.mysql.jdbc.Driver" / & gt; & Lt; संपत्ति नाम = "उपयोगकर्ता नाम" मान = "उपयोगकर्ता नाम" / & gt; & Lt; संपत्ति नाम = "पासवर्ड" मान = "पासवॉर्फ" / & gt; & Lt; प्रॉपर्टी नाम = "हटाए गए हटाए गए" मान = "सही" / & gt; & Lt; गुण नाम = "प्रारंभिक आकार" मान = "3" / & gt; & Lt; संपत्ति नाम = "अधिकतमअक्टिव" मान = "5" / & gt; & Lt; / सेम ​​& gt; डीबी से गुण मूल्यों को लोड करने के लिए अतिरिक्त कॉन्फ़िगरेशन। & lt; bean id = "config1" class = "org.apache.commons.configuration....
Read more