how to combine the result of two select statement in sql server

SQL UNION operator is used to combine the result sets of two or more select statements .

 1,174 total views,  1 views today