sql query confusing me
Posted on 2011-04-29
I have a table with all the acceses of the users to my website. In this table I just store the username and the date.
I need to get a list with the usernames that have logged in and how many times have they done it.
I'm confused about how can I use the 'group by' and 'count' modifiers to get this info.
user1, date 3
user1, date 4
user1, date 7
I will need to obtain the data:
user 1 - 3 times
user 2 - 1 time
user3 - 2 times
Probably it's trivial, but I can't handle it...
Thanks a lot and kind regards.