Interview Questions  
Home Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Go Back   Interview Questions > Interview Questions & Answers > Information Technology > Databases > DBMS
Reload this Page What is UNION,UNION ALL

DBMS DBMS Interview Questions, Learn by sharing DBMS Interview Questions asked in various Companies, Get Career advices, Interview Procedures from DBMS experts, Post asked DBMS Interview Questions and Answers.

   

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-28-2008, 05:48 PM
Senior Member
  
Join Date: Mar 2008
Posts: 4,634
Default What is UNION,UNION ALL
What is UNION,UNION ALL?
Reply With Quote
  #2 (permalink)  
Old 07-18-2008, 12:30 PM
Member
  
Join Date: Jul 2008
Posts: 39
Default
UNION retrives a single set of rows and columns removing the duplicated row.

UNION ALL retrives all the rows including duplication.
Reply With Quote
  #3 (permalink)  
Old 07-19-2008, 09:25 AM
Member
  
Join Date: Jul 2008
Posts: 36
Default
By Union btwn tables we retrieve set of rows with removing of duplicate rows from the query after union keyword
By union all means retreivin all rows.
Last edited by raghav; 07-19-2008 at 09:29 AM.
Reply With Quote
Reply

Tags
dbms, interview questions

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On








Contact Us - Interview Questions and Answers Discussion Community. - Archive - Top