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 / john
select * from table1
union
select * from table2
-- Union will give distinct value of both tables
Is This Answer Correct ? | 38 Yes | 2 No |
Post New Answer View All Answers
What does man by sql wildcard characters in sql server?
What is merge statement?
What are cursors stored procedures and triggers?
What is transaction server consistency?
Define right outer join in sql server joins?
Explain error and transaction handling in sql server?
What is the process of normalization?
what is hash nonclustered index
What is the difference between a fill factor of 100 and 0?
What happens if you add a new index to large table?
What is server-level principal?
How do I find query history in sql server?
what is the difference between openrowset and openquery?
What is the data type of time?
What are relationships and mention different types of relationships in the dbms