Is there such thing? i need to group a result set by weeks. Sort of like total sales of the week. How could I accomplish this? I really dont want the user to be entering a range of dates. The weeks will always start on Monday and finish on Sunday. My table takes daily sales.
Thanks