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 are the Properties of Sub-queries? Properties: We can use Order by only when we What is the difference and similarities between local and global temporary tables? Local Temporary tables Visible only to the current session. How to find the number of records in a table without using COUNT() function? It is possible by using MAX value of ROW_NUMBER() 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.