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
Explain what is the purpose of sql profiler in sql server?
Describe how to use linked server?
Explain having clause and where clause?
What is relationship? What number of sorts of relationship are there?
Define left outer join in sql server joins?
What are locks in sql?
Your table has a large character field there are queries that use this field in their search clause what should you do?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What is a schema in ms sql server 2005?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What is msdb database? : SQL Server Architecture
Can sql servers link to other servers like oracle?
what is a correlated sub-query? : Sql server database administration
How do I view a procedure in sql server?
What is the native system stored procedure to execute a command against all databases?