how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
UST,
1 5134in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
4 9748in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
3 9143Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
1 4083
What is node in db2?
How can deadlocks be resolved?
What are the full forms of spufi and dclgen and why are they used?
How do I delete a column in db2?
How to view db2 table structure?
How does a cursor work?
What does a deadlock mean in DB2?
What are foreign keys in db2?
What is a bind card?
What is the picture clause of null indicator variable?
What is drop table?
What is meant by dclgen?
Explain how can you do the explain of a dynamic sql statement?
What is dbrm?
What is the use of reorg in db2?