Mysql group function error,wanted a second max value -


getting error on below mysql query

invalid group function use

select logtime   sgwebdb.audit_log  logtime < max(logtime)    , userid = 'admin'    , activity = 'login'; 

try instead:

select logtime   sgwebdb.audit_log  logtime < (select max(logtime) sgwebdb.audit_log )    , userid = 'admin'    , activity = 'login'; 

update

for second max value can this:

select logtime  (    select logtime     sgwebdb.audit_log    userid = 'admin'      , activity = 'login'    order logtime desc    limit 2 ) t order bt logtime  limit 1; 

Comments

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -