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

Which are the dll’s used in sap business one sdk?

836


If we are Extracting Data From SD Application component.ie Ex:- sales and billing 2lis_11_vahdr & 2lis_13_vdhdr Data Sources.Can I load From These 2 Data Sources to sales overview Cube 0sd_c03.Can you Explain the procedure.

3226


What is a/r invoice ?

829


What is ‘sap business one’?

864


What is dbdatasource ?

1102


What is company object in sap business one ?

771


What is the value returned by a method when it executes successfully?

825


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?

3750


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.

1694


What are the different parts of di api ?

924


What is difference between transfer rules and update rules?

1772


Can we do aggregation in sap crm planning cube?

2607


What is di api in sap business one?

791


Where does di server executes i.e. Client or server ?

808


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

801