#DateForumTypeThreadPost
413 Jan 2015 @ 10:32 PSTDatabaseReplyRANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWINGDieter, The other Topic was based on the Time so extracting hour component from the eventtime helped to resolve it. Moh, If you can provide some sample data and what you are expecting, it would ...
313 Jan 2015 @ 10:21 PSTDatabaseReplyHelp coding on count historical event within a fix time period, greatly thanks! select user_Id,   rank() over(partition by user_id, extract(hour from logon_ts) order by logon_ts) -1 as rk  from table_name;   -Vrushang
224 Jul 2013 @ 08:35 PDTData ModelingReplyModeling for NUPI and USI combinationAs UPI are can not be created on the PK column how to maintain the uniqness of the records as per LDM ?? I guess you are trying to create partition  table with PK column not being the pa...
124 Jul 2013 @ 07:44 PDTDatabaseReplySecondary indexesKnowing that tables are loaded with mload so there won’t be any join index so  SI would help to join tables . I agree with Shelley. Creating a  valued order NUSI would be good, whe...