#DateForumTypeThreadPost
201 May 2016 @ 12:03 PDTDatabaseReplyNeed to write an SQL query as per the below data. create volatile table vt_data ( yr smallint, val smallint )on commit preserve rows; insert into vt_data values(2015,2000); insert into vt_data values(2015,3000); insert into vt_data valu...
130 Apr 2016 @ 11:35 PDTDatabaseTopicMin and Max date for every change in value of a flagHi All, I have a dataset that looks like this: ID        start_date    end_date       flag 12345  2014-06-04&...