What are the differences between UNION and JOINS?

Question Posted / saravakumar

Answers were Sorted based on User's Feedback

What are the differences between UNION and JOINS?..

Answer / saravakumar

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

Is This Answer Correct ?

7 Yes

0 No

What are the differences between UNION and JOINS?..

Answer / 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

What are the differences between UNION and JOINS?..

Answer / nikhila reddy

UNION:the both tables should have same structure and datatype.
the column name will taken as first table ones it wont bother abt other tables.
example:
emp table as
eid ename esal
1 a 10k
2 b 20k

dept table as
deptid deptname deptsal
11 aa 20k
12 bb 50k

select * from emp
union
select * from dept

empid empname empsal
1 a 10k
2 b 20k
11 aa 20k
12 bb 50k

now u can observe col name taking alias of first table.
no need of relation between a tables.
it will remove duplicate records.

joins:it will join only required fields from different tables.
no need of same structure for tables..
it should have relation between a tables.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL Server Interview Questions

How do you read transaction logs

1 Answers

What is the command to change the recovery model?

0 Answers

Can you please differentiate between a primary key and a unique key?

0 Answers

How can you fetch alternate records from a table?

0 Answers

How do you drop an index?

0 Answers

How to list all login names on the ms sql server?

0 Answers

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers

What are different types of table joins?

0 Answers

How to modify an existing user defined function?

0 Answers

What are the types of joins in sql?

0 Answers

Give an example of SQL injection attack ?

0 Answers HAL,

What are the 3 types of schema?

0 Answers

For more SQL Server Interview Questions Click Here