"view" data of last week,month,year [message #376867] |
Thu, 18 December 2008 23:59  |
sispk6
Messages: 164 Registered: November 2006 Location: pakistan
|
Senior Member |
|
|
hi i have a table
table user_login
{
empno ,
login_date ,
rec_id
};
its has data
empno logindate rec_id
11798 12/17/2008 1
11798 12/16/2008 2
11798 12/14/2008 3
11798 11/27/2008 5
11798 11/28/2008 4
11798 11/22/2008 10
11798 11/26/2008 6
11798 6/27/2008 7
11798 5/28/2008 8
11798 8/26/2008 9
i want to create a view that shows me login details as on
per week, per month , per year
view say V_LOGIN_DURATION (has field)
( pno , lastsevendays , lst30days , last365days).
kindly help im stuck at it.
Thanks
|
|
|
|
|