db2 question
Select messages from
 # through # FAQ
[/[Print]\]

MVSFORUMS.com -> Interview Q & A
#1: db2 question Author: Nithisha, Location: Pune PostPosted: Fri Mar 02, 2007 12:42 am
    —
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
#2:  Author: kolusu, Location: San Jose PostPosted: Fri Mar 02, 2007 6:29 am
    —
Nithisha,

1. Look Up Current timestamp
2. Group by key values with having count(*) > 1

Kolusu
MVSFORUMS.com -> Interview Q & A


output generated using printer-friendly topic mod. All times are GMT - 5 Hours

Page 1 of 1

Powered by phpBB © 2001, 2005 phpBB Group