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
- 12 Answers
- 15327 Views
- RBS, I also Faced
- E-Mail Answers
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
How do I start and stop sql server?
How to delete duplicate rows in sql server?
What is a trace frag? Where do we use it?
Can we call stored procedure in trigger?
What is catalog views?
What are number line correlation administrators will use while working with a subquery?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How can change procedure in sql server?
how would you store your query in an SSRS report or a Database server?
What is model database? : SQL Server Architecture
What is dynamic cursor in SQL SERVER?
What is an inner join?
What is PROJECTION Operation?
What is the default value of an integer data type in sql server 2005?
