What is the difference between in and exists.
Ex: select * from emp where empno in(....) and
select * from emp where empno exists(....)
What is the difference between a Join and Union and Union
and UnionAll.
- 5 Answers
- 9350 Views
- ABC, Accenture, I also Faced
- E-Mail Answers
Answer Posted / saradhi
Just like JOINS, UNION combines data into a single record-
set but vertically by adding rows from another table. JOINS
combine data horizontally by adding columns from another
table.
UNION insures you get DISTINCT records from both the tables.
UNION ALL pulls out all records from both the tables with
duplicates.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are transactions in sql?
What is store procedure? When do you use?
How to get the query of a table in sql server?
What is triggers and stored procedures?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What is rolap and its advantage? : sql server analysis services, ssas
Can you explain what is sql server english query?
How to execute a stored procedure in ms sql server?
How to scale out a federation by Sql statement?
What are points to remember while using the fillfactor argument?
What is key attribute?
What are the functions in sql server?
How to modify the underlying query of an existing view?
How much memory that we are using in Logshipping Concept?
