What are the differences between UNION and JOINS?
- 3 Answers
- 5530 Views
- CarrizalSoft Technologies, I also Faced
- E-Mail Answers
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
How to execute multiple stored procedures at one time in sql server?
How can we improve performance by using SQL Server profiler?
How to automatically create a log when an exception is being received into SQL Server?
What is a filestream?
System variable and temporary variables
What is a non clustered primary key?
How can we get count of the number of records in a table?
How to copy the tables, schema and views from one sql server to another?
Why I am getting this error when dropping a database in ms sql server?
What is table level trigger?
How to set database to be single_user in ms sql server?
what is the primary use of the model database? : Sql server administration
What is index, cluster index and nonclustered index?
Explain linked server in sql?
What is query and its types?
