Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11210 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 is a self join? : Sql server database administration
What is entity data services?
How to retrieve error messages using odbc_errormsg()?
Explain Capacity planning to create a database? and how to monitor it?
How to use column default values in insert statements in ms sql server?
what is checksum in sql server.........???
Write a SQL query to make a column as unique?
Explain few of the new features of sql server 2008 management studio
How to download and install the scaled-down database adventureworkslt?
How to list all triggers in the database with sys.triggers in ms sql server?
What are the new features in sql server 2016?
Do you know concepts and capabilities of sql server?
What is trace flag in sql server?
What will be the maximum number of indexes per table?
Why use sub query in sql server and list out types of sub queries?
