What technique is used to retrieve data from more than one
table in a single SQL statement?
Answer Posted / anjireddy vintha
By using JOINS and UNIONS we can retive data from
morethan one table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
List down the data types in the db2 database.
What are the 2 sqlcodes that are returned?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is a bind card?
What action db2 takes when a program aborts in the middle of a transaction?
What is schema 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.
What is rebind in db2?
How to check sequence on a table in db2?
What are the prerogatives?
What is image copy in db2?
How would the varchar column remarks defined?
What is ibm db2 client?
What is db2 bind process?
Explain package in db2 and its advantages?