What are the differences between UNION and JOINS?
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
Explain following error properties?
what authentication modes does sql server support? : Sql server database administration
How can I know what locks are running on which resource?
Does sql server 2000 clustering support load balancing?
What is molap and its advantage? : sql server analysis services, ssas
What do you understand by check constraint in sql server?
What do you understand by sql server agent?
Why is sql server log file full?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How many types of schemas are there?
What is sql server programming?
What is resultset concur_updatable?
Can sql servers link to other servers?
What is dknf in normalization form?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?