#DateForumTypeThreadPost
827 Jul 2014 @ 09:40 PDTGeneralReplyMAX() OVER () function producing inconsistent resultsThanks Dieter,  I have included the ORDER BY (as shown below) but still see inconsistent results where sometimes the SCND_INSD_GOVT_ID has the same value as INSD_GOVT_ID, when it should ...
725 Jul 2014 @ 12:35 PDTGeneralReplyMAX() OVER () function producing inconsistent resultsjust noticed, the expected results had a typo, pls use the below AGREEMENT_ID PDCR_ID OWNR_INSD_ORDER GOVT_ID INSD_GOVT_ID SCND_INSD_GOVT_ID 7475178 0000401450 1 123456789 123456789 ...
625 Jul 2014 @ 11:29 PDTGeneralTopicMAX() OVER () function producing inconsistent resultsHi experts, Have a SQL that goes something like this SEL AGREEMENT_ID , PDCR_ID , OWNR_INSD_ORDER , GOVT_ID , MAX(GOVT_ID) over (partition by AGREEMENT_ID, PDCR_ID rows between ...
516 May 2014 @ 10:10 PDTGeneralTopicOREPLACE gives an error, how to confirm its available hi    I get the below error when using OREPLACE() function SELECT OREPLACE('123-456-7890','-','') SELECT Failed. [3706] Syntax error: expected...
420 Apr 2014 @ 06:47 PDTDatabaseReplyQUALIFY <cond_1> AND <cond_2> filtered out valid dataTried multiple times and understand that the ROW_NUMBER() cannot gaurantee the assignment have used the  below construct which will work always SEL ... ( SEL ... QUALIFY MIN ()......
309 Apr 2014 @ 02:54 PDTDatabaseReplyQUALIFY <cond_1> AND <cond_2> filtered out valid data   Thanks dieter, yes it does make sense and i did notice that ROW_NUMBER() would sometimes assign 1 to the record that would be filtered out with the 2nd condition in the QUALIFY. ...
209 Apr 2014 @ 12:45 PDTDatabaseReplyQUALIFY <cond_1> AND <cond_2> filtered out valid dataTried reversing the order of the conditions in QUALIFY and it gave back the expected result, just dont understand it though - deepak
109 Apr 2014 @ 10:22 PDTDatabaseTopicQUALIFY <cond_1> AND <cond_2> filtered out valid dataHi I have the below resultset from a SQL, to which i add the QUALIFY (given below data) PRTY_ID PRTY_AGMT_RLE_CD FULL_NM SYS_ID AD_VER_DT OWNR_INSD_ORDER PRTY_ID IND 7286 ...