I am working in Oracle 9i. I have to fetch the previous logon date from the table where it contains all the logged dates of the users.
1. When a user logs in say on 24.08.2006 and that user's last login date was 21.08.2006.
In the table there is only one date column created_dt alone.
How do I take last login date of that user from that table where his max(created_dt) is 24.08.2006.
2. Also f I login as a user with one assigned role for 4 times in a day, the logins are coming as 1 for that role whereas if I login with a different role, then I am getting that login. I need to get all the logins from the table irrespective of the roles.