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
Answer Posted / alka
say table1 has col1 & table2 has col1 column
select col1 from table1
union
select col2 from table2
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
Tell me extended events in sql server 2008?
do you know how to configure db2 side of the application? : Sql server database administration
How to get the query of a table in sql server?
What is snapshot replication?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
how many no of arguments can be passed in procedures and functions
How to use subqueries with the in operators in ms sql server?
Is there any difference between the primary key and unique key?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
How do I clean up sql server transaction log?
What are the different types of replication are there in sql server 2000?
Can you roll back the ddl statement in a trigger?
How to enter comments in transact-sql statements?
How to identify current user in ssrs report?
what is sql server? : Sql server database administration