http://forum.lowyat.net/ Sat, 27 Jun 2026 05:28:03 +0800 FeedCreator 1.7.2 http://forum.lowyat.net/topic/2094479 I want to query the number count of row occurrence at different time period (e.g. 2pm-4pm, 4pm-6pm so on and so forth ) and put them into new column.<br /><br />Example:<br />Date 2pm-4pm 4pm-6pm<br />1st Jan 3 4<br />2nd Jan 4 1<br /><br />the table is as below:<br />anyone can give some light? <!--emo&:stars:--><img src='http://static.lowyat.net/style_emoticons/default/rclxub.gif' border='0' style='vertical-align:middle' alt='rclxub.gif' /><!--endemo--> i stucked at this stage, i tried union function but its not very practical and pretty hard-code.<br /><img src='http://i39.tinypic.com/n4h1lf.jpg' border='0' alt='user posted image' /><br /><br />Thanks in advance elexea Codemasters Thu, 03 Nov 2011 12:45:07 +0800