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 / amit
select * from table1
union
select * from table2
Is This Answer Correct ? | 21 Yes | 5 No |
Post New Answer View All Answers
Which tcp/ip port does sql server run on? How can it be changed?
How many types of cursor type are there?
How can we rewrite sub-queries into simple select statements or with joins?
Explain the difference between control flow and data flow?
What are the methods used to protect against sql injection attack?
Will sql server 2005 allow you to reduce the size of a column?
How to provide values to stored procedure parameters in ms sql server?
What is 1nf normalization form?
What are the different types of sub-queries?
How to round a numeric value to a specific precision?
How to manipulate data from one table to another table ?
Explain partitioned view?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
How to insert a new row into a table with "insert into" statements in ms sql server?
How do you clear a log file?