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
Post a Comment