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
- 14645 Views
- RBS, I also Faced
- E-Mail Answers
Answer Posted / guru
Union gives the result in two records
We have to use cross join like below
select * from table1,table2
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What is the difference between upgrade and migration in sql server?
How to find the login name linked to a given user name?
What is the full form of ddl?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
Why does sql studio use a single registered database repository? : sql server management studio
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
Can a unique index be created on a column, which contains null?
how you can deploy an ssrs report?
What is #temp and @table variable in SQL server?
How to join two tables in a single query in ms sql server?
What are the restrictions applicable while creating views? : SQL Server Architecture
How can you start sql server in different modes?
What is the data type of time?
How many types of built in functions are there in sql server 2012?
Can you explain what is indexed view? How to create it?
