What is PRIME TABLE and what are the uses of it
Answer / poonam
Prime Double Hash Table always uses prime number table sizes. The table is expandable, and the cost of rehashing is amortized across each insertion or deletion operation
| Is This Answer Correct ? | 0 Yes | 0 No |
what is REORG? what is the use?
what is the Foreign key? explain?
What is the role of data manager in the db2 database?
Can we update view in db2?
What is buffer pool in the db2 database?
how to check the table is empty or not?
What is an inner join, and an outer join ?
When the like statement is used?
What is explain in db2?
What is db2 purescale?
Name the various locking levels available?
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country