Interested to Buy Any Domain ? << Click Here >> for more details...
When Can you be sure that a query will return only one row?
- 4 Answers
- 8792 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / s
A Matching Index scan with equal predicate on a Unique
index will return only one row.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what is a corelated subquerry?
How can deadlocks be resolved?
How can the duplicate values be eliminated from db2 select?
What is the difference between dbm cfg and db cfg file in db2 ?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
can we view the access paths created by dbrm ? how ? thx
What is buffer pool and list some of them?
How do you find the maximum value in a column in db2?
What is the use of value function?
What is lock escalation in db2?
What is the physical storage length of time data type?
What is the use of predicate?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is db2 purescale?
