Interested to Buy Any Domain ? << Click Here >> for more details...
I have two tables A and B. Both tables are connected with SSN
number as foreign key. I want to retrieve a column data from B
table. How will you write a query?
- 3 Answers
- 9027 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / naidu sekhar yandrapu
SELECT SSN FROM B;
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Explain the function of data manager.
What does sqlcabc has?
How do I delete a table in database?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is runstats utility in db2?
How would the varchar column remarks defined?
How is deadlock resolved?
What is declare cursor?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Which component is used to execute the sql statements?
Define predicate?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is the syntax for seeing the columns and data types of a table in the db2 database?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Comment whether the cursor is closed during commit or not.
