Re: MySql SQL Help

2004-04-01 Thread Rhino
fferent modes supported by the week() function and make sure you pick the one that matches the rules in your environment. Rhino - Original Message - From: "Ramesh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 01, 2004 11:12 PM Subject: MySql SQL H

MySql SQL Help

2004-04-01 Thread Ramesh
Hi, Need a SQL/Design help. I have a table as follows: ORDER_HISTORY -- ORDER_ID | ORDER_NAME | ORDER_AMOUNT | ORDER_DATE -- 10 | Order 1| 20.00| 10-Jan-2003 11 | Order 2| 200.00 | 15-Jan-20