Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What technique is used to retrieve data from more than one
table in a single SQL statement?

Answers were Sorted based on User's Feedback



What technique is used to retrieve data from more than one table in a single SQL statement?..

Answer / islam

Join technique

Is This Answer Correct ?    11 Yes 0 No

What technique is used to retrieve data from more than one table in a single SQL statement?..

Answer / mani

Both UNION or UNION ALL and JOIN can be used.

The purpose of retreiving data from more than one table in a
single statement generally happens when the ouput of the
involved tables has same table structure and in this case
either UNION (to eliminate the duplicates in the resultant
table)or UNION ALL (to retain the duplicates in the
resultant table)could be used.

If retrieval is based on seletion criterion then JOINS could
also be used but here the resultant table structure can be
different from that of the tables involved in join operation.

Is This Answer Correct ?    6 Yes 0 No

What technique is used to retrieve data from more than one table in a single SQL statement?..

Answer / ravi

We can do this by using JOINS as well as Sub Queries

Is This Answer Correct ?    4 Yes 2 No

What technique is used to retrieve data from more than one table in a single SQL statement?..

Answer / rahul

select <column name of 1st table>,<column name of 2nd table>
from <Table name 1st>,<Table name2nd>;

Is This Answer Correct ?    2 Yes 0 No

What technique is used to retrieve data from more than one table in a single SQL statement?..

Answer / anjireddy vintha

By using JOINS and UNIONS we can retive data from
morethan one table.

Is This Answer Correct ?    1 Yes 0 No

What technique is used to retrieve data from more than one table in a single SQL statement?..

Answer / karthik

select <column name of 1st table>,<column name of 2nd table>
from <Table name 1st> join <Table name2nd> where
table1.columnname = table2.columnname;

atleast one column should be unique in both the tables.

Is This Answer Correct ?    1 Yes 1 No

What technique is used to retrieve data from more than one table in a single SQL statement?..

Answer / ajay rana

join techniques is used to to retrieve data from more than
one table in a single SQL statement.

Is This Answer Correct ?    0 Yes 0 No

What technique is used to retrieve data from more than one table in a single SQL statement?..

Answer / biryuk

UNION could be used to retrieve data from more than one
table as well.

Is This Answer Correct ?    2 Yes 3 No

What technique is used to retrieve data from more than one table in a single SQL statement?..

Answer / bala

Using Temp Table data can be retrieved from more than one
table.

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More DB2 Interview Questions

Before you give the explain statement, what are the prerogatives?

0 Answers  


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. TIA

8 Answers   CGI, Wipro,


What information is held in SYSIBM.SYSCOPY?

1 Answers  


we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  


What is -904 sql code? How to resolve it?

3 Answers  


What is sqlca’s maximum length?

0 Answers  


How do I import a csv file into db2?

0 Answers  


What is Skeleton cursor table (SKCT)?

2 Answers  


What is db2 plan table?

0 Answers  


What is database manager in db2?

0 Answers  


If I have a view which is a join of two or more tables, can this view be updateable?

0 Answers  


Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,


Categories