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
- 16078 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
your distribution database is full what will u do
What is normalization of database? What are its benefits?
What is not null constraint?
Differentiate between truncate vs delete in mssql?
Explain an incremental backup?
What is database isolation in sql server? : sql server database administration
Does transparent data encryption provide encryption when transmitting data across the network?
What is user-defined inline table-valued function?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
How use inner join in sql server?
What is a dbms wizard?
State a few properties of relational databases?
Do you know how to make remote connection in database?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What is simple indexing method?
