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

Mention what are the benefits of pl/sql packages?

542


What is trigger types of trigger?

556


what is rollback? : Sql dba

595


i have some prob lem to tell me about my self in interview first round ...

1706


How do you optimize a query?

540






Explain locks? : Transact sql

575


What is db journal file?

522


what is the command used to fetch first 5 characters of the string? : Sql dba

1139


How can I tell if sql is running?

592


What are the differences between implicit and explicit cursors?

523


Can we use two order by clause in query?

547


What is scope and visibility in PL/SQL?

604


What is difference between stored function and application function?

599


What is form and report?

521


what is the functionality of the function htmlentities? : Sql dba

525