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 the basic datatypes Char and Varchar? Char 1. It is fixed memory allocation. Ex: —————————————————- Round function Round: It Rounds the given expression into the specified Why/When do we need Cross Join? Cross Join: It is a kind of join that 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. This site uses Akismet to reduce spam. Learn how your comment data is processed.