database - MYSQL query with group function -


i want reach max value of serie value must less current value.

for example serie;

34 45 78 96 *114* 567  

and 114 current value. how can reach 96?

i tried below query giving error invalid use of group function

select ph_id `photos` max(ph_id)<114 group ph_id; 

if works replace 114 variable

try

select max(ph_id) `photos` ph_id < 114 group ph_id; 

Comments