what is the difference between join and union?
Answer Posted / ananda kumar
join retrive the data more than one table using single sql
query where as union combine the results of two or more sql
queries.
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How to create db2 table in mainframe?
How do I add a column to an existing table in db2?
What does runstats do in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
what is the responsibility of the construction superintendent
How to execute stored procedure in db2 command editor?
What is with ur in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
If I have a view which is a join of two or more tables, can this view be updateable?
How does coalesce work?
How to find the number of rows in db2 tables?
How to retrieve rows from a db2 table in embedded sql?
What is the use of commit in db2?
What is the difference between drop table and delete table?