C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !






use of Union and UnionAll


Posted Date: 18 Jun 2008    Resource Type: Code Snippets    Category: SQL
Author: Kapil DhawanMember Level: Gold    
Rating: Points: 5



table1

autoId MinisterName
01 Sonia Gandhi
02 Manmohan Singh
03 Lalu
04 Mayavati

table2

autoId MinisterName
01 Advani
02 Yashwant Singh
03 Chanderbabu Naidu
04 Mayavati


select MinisterName from table1
union
select MinisterName from table2

result will be of 7 records

MinisterName
Advani
Yashwant Singh
Chanderbabu Naidu
Mayavati
Sonia Gandhi
Manmohan Singh
Lalu


select MinisterName from table1
union all
select MinisterName from table2

now the result will be of 8 records
with Mayavati 2 times.



Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks      
Popular Tags   What are tags ?   Search Tags  
(No tags found.)

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: Use of LIKE wildcard
Previous Resource: display date-time in different ways
Return to Discussion Resource Index
Post New Resource
Category: SQL


Post resources and earn money! 		 
Related Resources


dotNet Slackers   BizTalk Adaptors    Web Design

Contact Us    Privacy Policy    Terms Of Use