#DateForumTypeThreadPost
217 Oct 2014 @ 07:43 PDTDatabaseReplyUpdate the table with min and max timestamp umanadh,   I suppose that the optimizer realizes that the data in the selected partition 'Y' is more than 99% of the whole table, so partition elemination would cost more th...
117 Oct 2014 @ 07:10 PDTDatabaseReplyUpdate the table with min and max timestampIf your example is correct, this should do it: SELECT name ,MAX(status) ,MIN(start_time) AS start_time ,MAX(CASE WHEN Status = 'C' THEN end_time ELSE NULL END) AS end_time FRO...