Need help with SELECT with GROUP and LIMIT

[Antonio Kurinski]

Hi,

I have site login log table and need to find LAST TWO logins for EACH user.
So, log table looks like:

+------------+--------+
| date | user |
+------------+--------+
| 2005.02.01 | mike |
| 2005.02.01 | john |
| 2005.02.01 | jenny |
| 2005.02.02 | mike |
| 2005.02.02 | john |
| 2005.02.02 | jenny |
| 2005.02.03 | mike |
| 2005.02.04 | john |
| 2005.02.05 | mike |
| 2005.02.05 | john |
| 2005.02.05 | jenny |
| ... | ... |
+------------+--------+

and result should look like (for EACH user LAST TWO logins):

+------------+--------+
| date | user |
+------------+--------+
| 2005.02.05 | mike |
| 2005.02.05 | john |
| 2005.02.05 | jenny |
| 2005.02.04 | john |
| 2005.02.03 | mike |
| 2005.02.02 | jenny |
+------------+--------+

Thx in advance for any idea how to write query for this!