[Solved] Yet Another SQL Query

by


It’s not entirely clear what you mean by “in the past 5 days“, but something along the following lines should do the trick:

SELECT COUNT(DISTINCT IDENT)
FROM   PS_LOGIN_LOG
WHERE  USER = 'someuser'
   AND TIME >= CURRENT_DATE - INTERVAL 5 DAY
   AND TIME <  CURRENT_DATE + INTERVAL 1 DAY

0

solved Yet Another SQL Query