#DateForumTypeThreadPost
7808 Oct 2015 @ 10:17 PDTDatabaseTopicIN Clause Hi Experts, Can anyone tell me the difference between below 2 queries . I know result will be same for both the queries but which one will better performance and why ?   delete from tableA ...
7706 Apr 2015 @ 08:11 PDTDatabaseTopic3606 two values were given for one field errorHi Experts,   I am trying to run below query but its giving error . Is there any other way write below query in one sql.   update ABC set elg_flg= case when cnt_grt_eql_50k>...
7623 Mar 2015 @ 08:05 PDTDatabaseReplyTranspose from columns to rowsyou are awesome Dieter Thanks :) Just wanna make sure , In the subquery you used Max function I guess it does not matter we use Max or Min? Is that right?
7520 Mar 2015 @ 01:48 PDTDatabaseTopicTranspose from columns to rowsHi Experts, I have a situation where I have to convert rows to columns    Input is :-   Cust_ID                       &nbs...
7417 Oct 2014 @ 11:00 PDTDatabaseReplyBusiness Day calculationThanks Raja :) but I was talking about Business Day calculation , this will give me total diffrence which will include weekends also.
7316 Oct 2014 @ 07:32 PDTDatabaseReplyBusiness Day calculationPlease help
7216 Oct 2014 @ 02:51 PDTDatabaseTopicBusiness Day calculationHi Experts,   I have got the situation where I have to get the 3 business day difference between two dates and if Yes then have to update the Flag accordingly.    date1  ...
7126 Sep 2014 @ 07:36 PDTDatabaseReplyQualify in select statementDieter I got it Thanks :)
7026 Sep 2014 @ 07:26 PDTDatabaseReplyQualify in select statementYes Raja what you said is correct I want only one row and extremely sorry for confusion
6926 Sep 2014 @ 07:22 PDTDatabaseReplyQualify in select statement SELECT ... FROM  (    SELECT ...       CSUM(TRXN_AMT)        OVER (PARTITION BY ACCT_ID...
6826 Sep 2014 @ 07:22 PDTDatabaseReplyQualify in select statementThanks Dieter but I want cumulative sum acct_id . sor_id and Trxn_Dt wise . THis query giving me CSUM across full table
6726 Sep 2014 @ 06:02 PDTDatabaseReplyQualify in select statementOk I have got one more way . In the below query it should give one row for combination of Acct_Id and Sor_Id whenever it reaches 300 . But this query is not working can you please tell me what is w...
6626 Sep 2014 @ 05:30 PDTDatabaseReplyQualify in select statementThanks Raja. But I am not looking for last day of the month. I want exact tran_dt whenever cumulative sum reaches 300 or more.
6525 Sep 2014 @ 03:27 PDTDatabaseReplyQualify in select statementHelp Please 
6425 Sep 2014 @ 02:19 PDTDatabaseTopicQualify in select statementHi Experts-  I have a situation where I have to find the TRXN_DT from below table that whenever the TRXn_AMT reaches 300 or more it should return that TRXN_DT. From below table it should be 0...
6309 Sep 2014 @ 06:44 PDTDatabaseReplyAND Condition after QualifyExperts - Please help 
6208 Sep 2014 @ 10:17 PDTDatabaseReplyAND Condition after QualifyAnd even if second one is working it should give the same result as first one
6108 Sep 2014 @ 10:15 PDTDatabaseReplyAND Condition after QualifyThanks for your response Below both queries works but gives different results   1. SEL ENT_CUST_ID, SOR_CUST_ID , ACCT_ID , SOR_ID, COALESCE (CURR_AMT , 0 ) AS CURR_AMT FROM GHP501_RAF_ACC...
6008 Sep 2014 @ 04:51 PDTDatabaseReplyAND Condition after QualifyThanks Dieter but in the first query ,why its accepting AND it should accept WHERE?
5907 Sep 2014 @ 06:20 PDTDatabaseReplyAND Condition after QualifyPlease help
5805 Sep 2014 @ 12:20 PDTDatabaseTopicAND Condition after QualifyHi Experts, I am using two queries which look similar only sequence of AND clause is different   First Query :-  SEL ENT_CUST_ID, SOR_CUST_ID , ACCT_ID , SOR_ID, COALESCE (CURR_AMT , ...
5729 Aug 2014 @ 06:35 PDTDatabaseReplyCASE Statement error please helpCan someone help please?
5628 Aug 2014 @ 01:53 PDTDatabaseReplyCASE Statement error please helphelp please
5528 Aug 2014 @ 12:24 PDTDatabaseTopicCASE Statement error please helpHi All,   While running the below query it gives me error ' Illegal expression in WHEN clause of CASE expression' . Can you please tell me what is wrong with the below code.   ...
5401 May 2014 @ 01:21 PDTDatabaseReplyRecursive Query IssueActually below sql is working for one row only but when i add below row it does not work , because there is no '|' . In the below code NONPROMO_POP is the table which contains those tw...

Pages