There is a table1 with records (1,2,3,4,5,6) and table2
with records (4,5,6,7,8,9).write a query so as to get the
result as 1,2,3,4,5,6,7,8,9
- 12 Answers
- 15923 Views
- RBS, I also Faced
- E-Mail Answers
Answer Posted / anil
select * from table1
union
select * from table2
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What is transact-sql language?
How to change the password of a login name in ms sql server?
How many levels of sp nesting is possible?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What does COMMIT command do?
What is bit data type? What's the information that can be stored inside a bit column?
How many partitions a clustered index has by default in sql server 2012?
What is filtered index?
How can I change procedure name in sql server?
What is a data source file?
Delete duplicate rows without using rowid.
What are the restrictions while creating batches in sql server?
Does index slows down insert statements?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
