I am having following table structure and sample values:
Code:
---------------------------------------------------------- APP_ID DATE HOUR STATUS_CODE HITS ---------------------------------------------------------- APP1 2011-15-03 12 200 50 APP1 2011-15-03 13 200 10 APP1 2011-15-03 14 200 5 APP1 2011-15-03 12 300 5 APP1 2011-15-03 13 300 1