Difference between UNION and UNIONALL

Answer Posted / harinath

the difference between Union and Union all is that Union all will not eliminate duplicate row

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase

1769


What is a/r invoice ?

634


my name is sandeep i want to join SAP Bi/BO hyd. can anyone suggest best institue or tranier with material also .sucess rate of them should be very good.. bcoz its very hard select insistiue in ameerpet...one and other all are same many people are misguided.. failling in interviews...if any one know please help answer this question so this will help others also

2178


Hi Friends, 1) What precautions i should take as a BI Consultant when it is to UPGRADE the version of ECC (Eg: from R/3 to ECC 6.0)? 2) Will this upgradation affect BI system anyway?

3533


What are the benefits of sap business one?

606






hi frnds dc's suma could u tell me. 1. expalin u have created any customize cube? 2. what is ur exp in bex and wad? 3. howmany reports u have created? give one scenario abour calculated key figure and formula? 4. tell me some recently what u have done tickets give me 2 tickets explain briefly? 5.what they (off shore team) have done ? what is cell formatting? and advantages?

2183


Is it possible to alter the standard behaviour of sap business one using sdk ?

608


In sap business one sdk, which object is used for executing sql queries and stored procedures ?

580


Hi everybody, This is Srinu,recently i got selected for a small comapny with sap b1 but i was new to the technology.I knew c#.net,asp.net,Sql server 2005.My question is what are the pre-required knowledge to learn SAP B1 please suggest me. Thanks & Regards.

1506


What is reconcile Adjustment Account in SAP Business One

2579


What is a/p invoice ?

624


Which tool is provided by sap for keeping the track of events ?

627


What is di server in sap business one ?

608


What is dbdatasource ?

915


What is the use of company object in sap business one ?

611