Wednesday 15 January 2014

mysql - Sql error : Invalid use of group function? -


Hi I want to select a line with the maximum ID (primary key) \ n \ mon_id = xyz

In the following I have my SQL script

  check = "Choose from * Notes, where id = in max (ID) (from select * notes, where patient _ID =" + patientopin. Tagatentid = "+") ";   

I am getting invalid usage of group function error, you can tell us the error.

You are trying to do this:

 select  * notes from where the patient_id =? Id dexc limit 1 order    

No comments:

Post a Comment