Hi @ScottPletcher.. What if i have additional columns in my table? for example name,loginID,loginDate, is it possible to also display the loginDate column?
You could easily display the first and/or the last date (and/or some average of the two). You can show all dates by converting them to strings and concatenating them, but that's a lot of code and overhead.
SELECT name, COUNT(*) AS totalLogin, MIN(loginDate) AS FirstLogin, MAX(loginDate) AS LastLogin
FROM table_name
GROUP BY name
--ORDER BY name
@ScottPletcher What if i want to get the totalLogin in a particular date? is it possible? for example, student A has a totalLogin of 2 on Nov 23 2015// is it possible then?