What is the difference between join and union.

Answer Posted / vinay shukla

A join selects columns from 2 or more tables.
a union selects rows

Is This Answer Correct ?    60 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is big data nosql?

505


Which are the different case manipulation functions in sql?

528


What does varchar include?

512


How do I send sql query results to excel?

565


What are primary key and foreign key and how they work?

538






Can we use join in subquery?

561


How many functions are there in sql?

530


What is bulk collect in pl sql?

519


Which are the different types of indexes in sql?

549


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2563


Why is the cursor important?

526


Show the cursor attributes of pl/sql.

600


What is left join in sql?

571


what are the type of locks ? : Sql dba

521


How do I sort a table in sql?

585