Sunday, October 14, 2012

Union key word use in SQL

union is a special operator we can use to cause two or more queries to generate one result set. All the      union queries must have the same number of columns in the SELECT list. Data type should be same of columns in select queries. By default union operator result is distinct which means same data in column will eliminate.

select employeename from empoyee
union
select suppliername from suppliers

see more information plz visit

No comments:

Post a Comment