Facebook

Record

SQL Server UNION, INTERSECT and EXCEPT (MINUS) clauses

Union is to select all records from two table but common record only once. Select * from tbemp1UNIONSelect * from tbemp2 Inersect is to select common records from two tables. Select * from tbemp1INTERSECTSelect * from tbemp2 Except(Minus) is equivalent to oracle minus clause. Select records of table 1 which are not in table 2. Select * from […]