What technique is used to retrieve data from more than one
table in a single SQL statement?
- 9 Answers
- 12968 Views
- CTS, IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / ravi
We can do this by using JOINS as well as Sub Queries
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is sqlca?
How do I start db2 in windows?
what is db2 restart?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
B37 abend during spufi?
Can we update view in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Define predicate?
How to access db2 tables in mainframe?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What type of database is db2?
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 ?
What is db2?
What is the physical storage length of date data type?
Define declaration generator (dclgen).
