Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between UNION and JOINS?
- 3 Answers
- 6285 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
What is the difference between osql and query analyzer?
what are the new features introduced in sql server 2000? : Sql server database administration
How optimize sql query with multiple joins in sql server?
Differentiate between a having clause and a where clause.
How to insert data into an existing table?
How can we solve concurrency problems?
Will count(column) include columns with null values in its count?
What is a transaction and why is it important?
What are the different types of stored procedures?
When is update_statistics command used?
What are the joins in sql server? : sql server database administration
How to find the version of sql server? : sql server database administration
What are the restrictions applicable while creating views? : SQL Server Architecture
Please illustrate physical database architecture? : SQL Server Architecture
What is the difference between having clause and where clause in sql server?
