What is the difference between join and union.

Answer Posted / sat kumar

Union:- Union return the common data in the form of rows

Join:- Joins always returncommon Data in the form of Column
if oyu have some suggetion about this then plz call
me at this is my no
+91-9868591907

Is This Answer Correct ?    19 Yes 35 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between sql function and stored procedure?

514


What do you mean by rowid?

546


What is difference between table and view?

533


What are sql built in functions?

522


If a cursor is open, how can we find in a pl/sql block?

690






What is the usage of nvl function?

605


What is the most important ddl statements in sql are?

532


What is information schema in sql?

588


Is t sql a programming language?

547


Explain the the delete statements in sql?

585


What is trigger types in sql?

543


What is a unique key and primary key and foreign key?

576


What is an invalid partition table?

576


Is a foreign key always unique?

543


Can we insert data into materialized view?

531