Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17671 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
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
what are the three command line utilities and what are their primary functions?
How can we delete Duplicate row in table?
What is cube dimension? : sql server analysis services, ssas
Can sub report data source be different from that of the parent report?
What is query and its types?
How network traffic be reduced by using the stored procedure?
What are recommended options to be used while using db mirroring? : sql server database administration
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What part does database design plays a role in performance of an sql server-based application?
Explain the advantages of merge replication?
How to create an index on a view?
How do I run sql server 2014?
What is the ‘fillfactor’?
Can you get second highest salary from the table?
