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

What are the limitations of di server?

648


What will happen if we remove eventfilters ?

590


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

574


What is di server in sap business one ?

597


What is the function of observerdll.dll ?

807






How to fill data in recordset ?

697


What is the function of ui api i.e. User interface api ?

644


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

619


hi guys, now i am working in very small company for SAP_BusinessOne...after getting 3 years of exp in this company ..can i move to LEVEL5 Big Mnc's? any chance is there? or can i change technology instead of B1?

1812


Explain core modules of sap business one?

560


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.

3025


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

2173


What are the different parts of di api ?

689


Which table saves the details of country ?

587


What is ‘sap business one’?

612