UNION:The SQL UNION operator combines two or more SELECT statements. JO

What are the differences between UNION and JOINS?

Question Posted / sree

Answer Posted / sree

UNION:The SQL UNION operator combines two or more SELECT
statements.

JOINS:SQL joins are used to query data from two or more
tables, based on a relationship between certain columns in
these tables.

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why can there be only one clustered index and not more than one?

1005

Explain what is log shipping?

1136

What are the triggers in sql?

1105

What is sleeping status in sql server?

1023

What are “lost updates”?

1001

What are the advantages of policy management?

997

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

978

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1080

What are the advantages of having an index on the sql server?

925

What command is used to rename the database?

1014

What does select 1 mean?

928

What is lock escalation? : sql server database administration

1160

How can we delete Duplicate row in table?

1066

What are drillthrough reports?

155

Distinguish between commit and rollback?

963