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
How to assign null values to variables or columns?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
Explain aggregate functions?
What are the steps you can take to avoid “deadlocks”?
What is the difference between commit and rollback?
What is similarity and difference between truncate and delete in sql?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
what is the information that can be stored inside a bit column? : Sql server database administration
What are the limitations/drawbacks or ssrs 2008 r2?
Determine when an index is appropriate?
Explain the properties of a relational table?
what are the reporting service components in SSRS?
what kind of lan types do you know? : Sql server database administration
what is raid and what are different types of raid configurations? : Sql server database administration
How to use go command in "sqlcmd"?