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 4266in 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 7672in 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 7494Can 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 3276
Mention the downsides of page level lock.
What is innodb buffer pool?
What is scrollable cursor in db2?
What is dpf in db2?
What are the benefits of using the db2 database?
What is runstats utility in db2?
What is rct?
List out the three types of page locks that can be held.
How many databases are there?
What's The Percentage Free Space ?
What is a dbrm in db2?
Why db2 is called db2?
What is meant by explain?
What is with ur in db2?
How can you count the number of rows from a table tab?
