View previous topic :: View next topic |
Author |
Message |
Nithisha Beginner
Joined: 27 May 2006 Posts: 23 Topics: 13 Location: Pune
|
Posted: Fri Mar 02, 2007 12:42 am Post subject: db2 question |
|
|
hi
Friend i have come query regarding Db2
it is may be ease for other dont mistake if the question is silly.
1) how to get only timestamp from the table.
2)how to get only a duplicate from single table.
thanks in advances
Nithsha |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12367 Topics: 75 Location: San Jose
|
Posted: Fri Mar 02, 2007 6:29 am Post subject: |
|
|
Nithisha,
1. Look Up Current timestamp
2. Group by key values with having count(*) > 1
Kolusu _________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
|
|