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
- 8721 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / siri
1)select ssn from b;
2)select b1.ssn from a a1,b b1 where a1.ssn=b1.ssn
3)seelct b1.ssn from a a inner join b b1 on a1.ssn=b1.ssn
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can there be more than one cursor open for any program?
What is the maximum number of columns in a db2 table?
What is image copy in db2?
What is the connection string to connect to the DB2 Database ?
Explain dclgen.
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Discuss about db2 bind?
What is the use of commit in db2?
What is the function of logging in the db2 database?
What are host variables in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is phantom read in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Which command is used to remove all rows from a table?
Can you tell me how can you find out the # of rows updated after an update statement?
