Re: sql query(group by + order by)

by clause is causing undesired results. - Original Message - From: "lorenzo.kh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 10, 2002 6:53 PM Subject: sql query(group by + order by) > Hi, > I got a table named patient_treatment_history &g

sql query(group by + order by)

Hi, I got a table named patient_treatment_history Below is some of the records inside the table. patient_id,treatment_date,charges 1014,2002-01-28,20 1001,2002-02-02,100 1026,2002-04-08,74 1001,2002-04-15,85 1014,2002-05-05,50 1030,2002-05-16,125 1030,2002-06-18,180 1001,2002-06-25,125 I try to