Hi I have a column "TOTAL" which is adding numbers in it rows.I am using SUM Function for that. Problem-I dont want the sum of all rows .I want sum of only last 5 days before system date. for example if today is 29 october as per my computer.I want summantion of 23+25+26+27+28+29(24 not included as it is sunday).
it would be greate if solution would be specific
is that possible if yes how? present query SUM(TOTAL)