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

Popular posts from this blog

html - How to style widget with post count different than without post count -

How to remove text and logo OR add Overflow on Android ActionBar using AppCompat on API 8? -

javascript - storing input from prompt in array and displaying the array -