#DateForumTypeThreadPost
705 Aug 2016 @ 02:03 PDTDatabaseReplyHow do i write qualify rank() over (partition.....questionHi, subscriber1  ||   pkg1  ||  23 Subscriber2 ||    pkg2  || 42  . . . SubscriberN || pkg1  || 50 ----------------------------------------------...
621 Mar 2016 @ 05:01 PDTDatabaseReplyCASE statement in SQLHi, My table has data: C1, jan, 23 || C1, feb, 55 || C3, march, 100 .   I am joining it with another table and want it to be like: ||||col1 ||janPayment|| febpayment|| marchpayment||||...
509 Mar 2016 @ 08:19 PSTGeneralReplyTeradata SQl Query with Group by Thank you it worked perfect! :) 
409 Mar 2016 @ 10:14 PSTGeneralReplyTeradata SQl Query with Group by Hi why I am getting group by error for this: SEL bpft.ACCT_ID,  CASE WHEN bpft.BILL_PMT_DT BETWEEN ('2015-06-01') AND ('2015-06-30') THEN  SUM(bpft.TOTAL_PMT_AMT) ...
309 Mar 2016 @ 08:15 PSTUDAReplyconvert varchar to timestampI have a col with data like: 23/11/2015 10:10:00. I want to convert it to Timestamp but it's giving error: Invalid timestamp. SEL  CAST(ab.Dt AS TIMESTAMP(0) FORMAT 'MM/DD/YYY...
210 Mar 2015 @ 10:41 PDTDatabaseReplyCASE statment inside where clause and corelated subquery ERROR:3707Thank you so much, it worked perfect!
110 Mar 2015 @ 04:22 PDTDatabaseTopicCASE statment inside where clause and corelated subquery ERROR:3707 SELECT  oute.* FROM PDP_TMP.EV_SBSCRP_BTS_USG oute WHERE   CASE WHEN oute.PROD_TYPE= EVO THEN oute.TotalDataCount  =  SELECT  MAX (inne.TotalDataCount) ...