What are the basic rules to be followed when you are using SQL SET Operators? Posted in SQL Interview Questions by Chandrasekhar Raparthi On July 10, 2014. No comments Rules: Number of columns in all the result sets should be matched(same). Respective data types should be matched between all the result sets. Share this:GooglePinterestEmailTwitterLinkedInFacebook Tags:set operators,SQL Related Posts What is the difference between REPLACE() and STUFF() functions? REPLACE() It is used to replace all the occurrences of What is the basic difference between DELETE and TRUNCATE commands? DELETE It is a DML command We can use What is the difference between the Database and Datawarehouse? Database It contains Normalized data Group of databases form Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment Name * Email * Website Notify me of follow-up comments by email. Notify me of new posts by email.