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 5868in 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 11373in 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 10603Can 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 4812
How do you find the maximum value in a column in db2?
How to get the ddl of a table in db2?
What are the various isolation levels possible?
what is diffrence b/w file-aid tool and file-aid utility???
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is a db2 collection?
On which levels locks can be applied?
What is a bind in db2?
What is reorg?
What is db2 optimizer?
What's The Percentage Free Space ?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is copy pending and check pending in db2?
What is blu acceleration in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.